Forum Discussion
Dynamic column generation using DAX
PROFSUMMARY = SUMMARIZE ( Hi, Training, Training[ID], Training[Prof], "DP101", CALCULATE ( SUM ( Training[Att Hrs] ), Training[Code] = "DP101",Training[Mode] = "Virtual" ), "DP103", CALCULATE ...
Hi axiosfabric
Maybe you can try to use the Pivot Column feature in the power query:
Open the Power query, select the code column and click the pivot column in the transform pane:
Then Select Hrs in the Value Column box and select Sum in Aggregaet Value Function box:
Click Close & Apply:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.