![]() I tried to google on this topic but i can't find anything on it. I see that PowerPivot/BI are not limiting by rows anymore and i'm wondering if it is better than Access. Power Query a.k.a M) which can not be expected to be created by someone who is new to i'm hoping to pick your brain regarding using PowerPivot / Power BI instead of using Access to create a database. If you would use the gear button behind the name of the code step, then the "Invoke Custom Function" popup pops up and you won't be able to use this.īy the way: this is rather advanced Get & Transform (a.k.a. Should you want to adjust this line of code, then it can only be done via the formula bar or the advanced editor. Note: the last line is created via option "Add Custom Column" on the "Add Column" tab it is not possible to use option "Invoke Custom Function", because you won't be able to supply the required parameters. It returns the values in the sequence of the provided Columns you may even include 1 column multiple times.ĬombineColumnValues = (Source as record, Columns as list) =>ĬolumnPositions = List.Transform(Columns, each if _ is number then _ else List.PositionOf(Record.FieldNames(Source),_)),ĬolumnValues = List.Transform(ColumnPositions, each Record.FieldValues(Source))) ![]() ![]() That's why it is so important to provide respresentative example data.Īnyhow, that complicates matters I've written this custom function, that will give you the combined values of the Columns, which is a list with either column numbers (base 0) or column names or mixed names and numbers). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |