Forum Discussion
List Transform with Extra Columns
Hi mussaenda ,
the key is NOT to write the function for the binary extraction by hand, but to use the "Expand binary"-method by clicking the arrows in the column like described here:
https://www.excelguru.ca/blog/2016/12/21/new-combine-binaries-experience/
This will automatically create a couple of queries, one of them the function itself, and another a query that is "married" to the function: All changes you make there will be reflected in the function as well. That's very convienent in my eyes and keeps the name-column.
Hi mussaenda ,
the key is NOT to write the function for the binary extraction by hand, but to use the "Expand binary"-method by clicking the arrows in the column like described here:
https://www.excelguru.ca/blog/2016/12/21/new-combine-binaries-experience/
This will automatically create a couple of queries, one of them the function itself, and another a query that is "married" to the function: All changes you make there will be reflected in the function as well. That's very convienent in my eyes and keeps the name-column.
Hi MFelix , thanks for recommending ImkeF !
Hi ImkeF , as always, you are a great help to this community.
I am more comfortable with Power Query than DAX but I only knew now that I can touch the Tranform File crerated when I clicked the arrow from column header.
What I always do is load everything then transform from there.
The only downside of this is that, if the formula of my custom columns are not correct and the data of my mention columns are changing, I am encoutering error and cannot trace where the error is since I can only see the sample file.
But hey, your links and tips are very helpful to newbies like me. I will do this tip from now on to all my reports with xls files and csv.
And also, it solved my question! Thank you so muchhhhhh!