Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Enable future date in Reporting with Cummulative Sum

Hi All,   My sales table has data from Jan till May. In the report, I want to show cummulative sum on Sales quantity. Future Months. i.e June till Dec , should also show last cummulative data until...
Need Help
Show and Tell
Tips and Tricks
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ，

 

First go to "edit queries">"Add column">"Index Column">"From 1":

Then go to "data view">"Modeling">"New column",adding a dax expression as below:

 

Column = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Index]<=EARLIER('Table'[Index])))

 

 

Finally you will see :

 

 

For the related .pbix file,pls click here  .

 

Best Regards,
Kelly

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-kelly-msft amitchandak SQLbyoBI 

     

    Thanks every one it was informative replies. The easiest solution for me was to create a seperate Date Table and then make a JOIN. Althought, this was quite slow in my power bi desktop, so I preferred to JOIN in SQL Database.