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

 

Rolling total working good for me can you check once again and if its possible can show some ref images 

Atif's avatar
Atif
Resolver I
8 years ago

Anonymous

 

To avoid any error being carry forwarded, I connected a fresh set of data (fictitious), yet nothing happened with "quick measures".

 

The result of the two measures "Year-to-date total" and "Running total" is as under.

Month NameFY12FY13FY14FY15FY16FY17FY18Total
July     302     332     378     393     408     438     453    2,703
August     302     332     378     393     408     438     453    2,703
September     302     332     378     393     408     438     453    2,703
October     302     332     378     393     408     438     453    2,703
November     302     332     378     393     408     438     453    2,703
December     302     332     378     393     408     438     453    2,703
January     302     332     378     393     408     438         -      2,250
February     302     332     378     393     408     438         -      2,250
March     302     332     378     393     408     438         -      2,250
April     302     332     378     393     408     438         -      2,250
May     302     332     378     393     408     438         -      2,250
June     302     332     378     393     408     438         -      2,250
Total  3,624  3,986  4,530  4,711  4,892  5,255  2,718  29,717

 

The result of other three measures "Year-over-year change", "Month-over-month change" and "Percentage difference" is:

Month NameFY12FY13FY14FY15FY16FY17FY18Total
July0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
August0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
September0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
October0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
November0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
December0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
January0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
February0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
March0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
April0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
May0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
June0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Total0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%

 

Please note that I have tried to work with both "calendar year" and "fiscal year".

 

All I need now is a measure for:

- YTD Revenue;

- YTD Revenue for previous years;

- YoY Difference; and

- YoY Variance