Forum Discussion

Snagalapur's avatar
Snagalapur
Helper IV
6 months ago
Solved

Cumulative phasing

Hi All,   Kindly suggest how to modify below measure to show cumulative values ie.. P01 = P01, P02 = P01 +P02, P03 = P01 +P02+P03   Budget PNL = VAR LC= CALCULATE(SUM(FACT_DATA[AMOUNT]), FILTER...
Need Help
  • Snagalapur's avatar
    Snagalapur
    6 months ago

    no problem. I did try below code block to modyfy my formulas and this works 

    Cumulative Sales = 
VAR MaxDate = MAX('DateTable'[Date])
RETURN
CALCULATE(
    SUM('Sales'[Amount]),
    FILTER(
        ALLSELECTED('DateTable'),
        'DateTable'[Date] <= MaxDate
    )
)

     

     

Snagalapur's avatar
Snagalapur
Helper IV
6 months ago

Thnak you for taking time, I did modify content to provide more details.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 months ago

sorry but still cannot understand.

  • Snagalapur's avatar
    Snagalapur
    Helper IV
    6 months ago

    no problem. I did try below code block to modyfy my formulas and this works 

    Cumulative Sales = 
VAR MaxDate = MAX('DateTable'[Date])
RETURN
CALCULATE(
    SUM('Sales'[Amount]),
    FILTER(
        ALLSELECTED('DateTable'),
        'DateTable'[Date] <= MaxDate
    )
)