Forum Discussion

Spetter's avatar
Spetter
Advocate IV
8 years ago

Cumulative total

Hi,   I am making a cumulative percentage and I am using the DAX pattern to do this. However, I need a slight customization. If I select Q2 I want the cumulative percentage to cumulate the percent...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

If someone selects Q2 in the slicer, then in the Table do you want to compuate the cumulative for Q3 as Q1+Q2+Q3 or should it be Q2+Q3?

Spetter's avatar
Spetter
Advocate IV
8 years ago

When a user selects Q2 in the slicer it should calculate the percentage for Q3 in the chart for quarter 3 and it should calculate the percentage for Q3+Q4 in the chart for quarter 4.

 

But the calculation for "% actuals" from Q3 = Actuals Q3/Budget Q1

and the "% actuals" from Q4 = Actuals Q3/Budget Q1 + Actuals Q4/Budget Q1

 

I just need the cumulative % to start after the selected quarter but for some reason it also cumulates the % actuals for Q1 and Q2 in quarter 3 and quarter 4 :s

 

I thought I was close but the IF-statement only works for not showing the % in Q1 and Q2 and doesn't work to let the cumulative % start from after Q2.