Forum Discussion
JishnuGS
3 years agoFrequent Visitor
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...
- 3 years ago
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
JishnuGS
3 years agoFrequent Visitor
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