Forum Discussion
Problem calculation Rolling total for Non-date fields
Hello,
I have issue in calculating the rolling Sum total for "Total Value Change" coulmn.
I need dynamic cummulative total. The measure which I am using is:
-> This DAX is not working and It is difficult to find the Rolling total. This measure Works if we use it only for Card.
Example of card:
This matches the total but when I drag this formula to the Table, it throws error.
Thanks!
3 Replies
- parry2kSuper User
Anonymous I think you are looking for a running total by material number, check this video on how you can achieve this using new DAX functions: How new WINDOW DAX functions makes running total super easy in Power BI - YouTube
- BITomSSolution Supplier
Hi Anonymous ,
There is an answer here: https://javierguillen.wordpress.com/2012/02/06/can-earlier-be-used-in-dax-measures/
Hope this helps.