@cummilative

4 Topics

Cumulative total across measure value
Hi everyone, I have few measures which calculate Total number of case created , case closed , net change per month. I would like to create another measure called "Stock" which will add the value of "Net Change" into next month. For example we start with stock value as 7 which is the "Net Change" value for the month of January , as we move to February I would like the measure to calculate stock value of February as sum of January Stock value + Net Change of February = 7+2= 9. Similary I would like to calculate the Stock of March as sum of February Stock Value +March Net Change =9+2=12. Any help on how to calculate the stock column would be greatly appriciated. Month Total Created Total Close Net Change Stock January 14 7 7 7 February 5 3 2 9 March 12 10 2 12 April 6 4 2 14 May 2 10 -8 6
Solved
biswad
1 year ago Place DAX Commands and Tips
942Views
0likes
4Comments
5 years rolling data based on slicer (year) selection
Hi All, I have a requirement that needs to display 5 years of data if selected YTD, 12 months of data if selected MTD, selected month && 4 quarters of data if selected QTD. How do I get 5 years of data? Please drop me your suggestions or answers.
Powerbyosh
3 years ago Place DAX Commands and Tips
760Views
0likes
2Comments
cummilative line graph using Rolling 30 days
Hi All, Currently i have calculated Rolling 30 days average , i want to display Rolling 30 days cummilitive amount. Thanks, VAdi
VikramAdi
3 years ago Place DAX Commands and Tips
869Views
0likes
2Comments
Rolling
VikramAdi
3 years ago Place DAX Commands and Tips
2.1KViews
0likes
8Comments