I want to sum the previous month with the current month dynamically.
For example : Feb=100 , jan = 10 ,march = 20 result on march ( current month ) should be march + jan + fed = 130.
1 ACCEPTED SOLUTION
This is the appropriate measure for tackling this.
Running Total =
CALCULATE (
COUNTROWS ( Sales[SalesAmount] ),
FILTER (
ALL (Sales),
Sales[DateKey] <= MAX ( Sales[DateKey] )
)
)
This is the appropriate measure for tackling this.
Running Total =
CALCULATE (
COUNTROWS ( Sales[SalesAmount] ),
FILTER (
ALL (Sales),
Sales[DateKey] <= MAX ( Sales[DateKey] )
)
)
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
