Forum Discussion
DAX Month Cummulative using SUMX RANKX
Hello I am trying to work out the cumulative amounts for each month using the following dax queries with Rankx. Month Numbers =
SWITCH([Total Sales Ranking by Month],
"JAN", 1,
"FEB", 2,
"M...
If you're looking to do cumulative sum based on column that is not date, you may find this helpful: https://community.powerbi.com/t5/Desktop/Cumulative-SUM-using-Rank-NOT-Dates/m-p/170623