Hi,
I have the following table and i'm looking to create a line chart in Power BI as per the example below (please excuse the drawing). How do I get a running total of 'Items' on each date? i.e. for 'Admin', on the 4/6/2024, the total on the line chart would be 40.
Example of running total:
Thank you,
Daniel
1 ACCEPTED SOLUTION
Hi @dankello ,
Try to create the following measure:
Total Values = CALCULATE( SUM(Table[Items]), Table[Date] <= MAX(Table[Date]))
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @dankello ,
Try to create the following measure:
Total Values = CALCULATE( SUM(Table[Items]), Table[Date] <= MAX(Table[Date]))
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
