Forum Discussion
Calculated Table Column Headers
Hi, I have a calculated table like this: Now, the 2nd Last Week and Last Week names come from my code, where I specify these names so they are hard coded. I want them to instead represent t...
Hi, Anonymous
What you mean is that you want to be able to dynamically modify the column names according to the date?
Unfortunately this may be difficult to achieve through DAX, but this is not completely impossible to achieve,
it can be done by using M code in the power query, but unfortunately this forum is not a forum dedicated to discussing powerquery, I suggest you look for answers in the power query forum or create a New Message in the forum for help. This is all I can do, I hope this is useful to you
Here is the link to the power query forum:
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.