Greg_Deckler
Community Champion
Community ChampionDAX Unpivot
At a recent user group meeting in Columbus Ohio, one of my members presented me with a problem they were having. The member was working with a SharePoint list and attempting to unpivot a number of co...
This is great, but one thing is missing for me.
In the table on the right, the column headres are stored in the "Purchase type" column (what would be the Attribute column in Power Query), while this DAX code doesn't create that attribute column. Any ideas on how to achieve that?
I am not sure what I amissing but I am with Nart, the column headers NEED to be dynamic. The Union trick is helpful but you are hardcoding "Column1", etc. How do we generate the "Purchase Type" column from large number of columns like attribute column in Power Query, except of course with distinct values...?
