Forum Discussion
Promote Headers via dax or not use function Promote headers
Hi Jyaulhaq ,
Thank you for the update. DAX can’t dynamically promote headers when you have n number of columns. Any DAX approach would require listing each column manually, so it won’t update automatically if columns change.
If you need it to work dynamically, the only option is to do it in Power Query or make sure the source already has the correct headers before loading.
Best Regards,
Community Support Team
Super UserDAX does not handle table manipulation in terms of headers, so you have no options in DAX
In Power Query, either you click the Promote Headers button or you can use the M function Table.PromoteHeaders
The only way to avoid this step is loading from a Database where this thing is unnecessary since headers are defined in the database itself
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI