Forum Discussion
Solved
How to create QTD in Power Query Editor ?
Hi Team, I have data like below, i want to calculate QTD for this. Empl Oct Sales Nov Sales Dec Sales Jan Sales Feb Sales Mar Sales A 12 3 14 6 0 10 B 5 13 7 6 4 8...
We have unpivoted the colunms and created a new Colunm for Qtr label then created a Groupby for the new column to get the Qtr sum
You can build QTD easily in Dax, i am not sure what the use case is but maybe you want to avoid Power Query Editor for this 1 and just use https://learn.microsoft.com/en-us/dax/totalqtd-function-dax.