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
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.

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