Forum Discussion
Running Total Without Reset
Thank you for your reply.
I did manage to get it to work with the YYYYWW format, but found it to be less nice on the UI side of things if I plot it in a bar graph (with the Year and Week of Year combination I can nicely collate them).
But I think I will just have to live with that and go for the YYYYWW solution.
Thank you!
spmvoss ,
You to create a combined measure YYYYWW and use that.
Or you can use Week Rank, Like I have used in file : https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
CALCULATE(
SUM('MAMUT'[Hours]),
FILTER(
ALLSELECTED('MAMUT'[Week of Year]),
ISONORAFTER('MAMUT'[Week Rank], MAX('MAMUT'[Week RANK]), DESC)
)
)
Better you move Week outside your fact in a new table and create week Rank there.
Thank you for your reply.
I did manage to get it to work with the YYYYWW format, but found it to be less nice on the UI side of things if I plot it in a bar graph (with the Year and Week of Year combination I can nicely collate them).
But I think I will just have to live with that and go for the YYYYWW solution.
Thank you!