Forum Discussion

Atif's avatar
Atif
Resolver I
8 years ago

Running Total

The following formulae are displaying each month's respective figure rather than a running total.   "YTD Revenue = CALCULATE(SUM(Table1[Revenue]),FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<=MAX(...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Atif

 

Just to give an idea you can make use of quick measures it may help you out. refer the image below

 

 

Atif's avatar
Atif
Resolver I
8 years ago

Hi there Anonymous

 

Thanks a bunch!

 

The quick measure "Running Total" is displaying respective month's figures without adding up in following months.

 

Moreover, I need running total based on Fiscal Year (July to June).

 

The result of quick measure "Year-to-date total" is blank report.