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,

 

I think the disconnected table is required but that should be the same as the Date Table.  Thereafter, we can try this measure

 

=CALCULATE([Percentage actuals],DATESBETWEEN(Measuretable[Datum],MIN(Disconnectedtable[Date]),MAX(Measuretable[Datum])))

Spetter's avatar
Spetter
Advocate IV
8 years ago

Hi

 

I tried the solution:

  • made a new disconnected table with all the dates
  • made a new measure and put it on the chart
  • made a new slicer with "quarter" from the new disconnected table

 

but it doesn't seem to work (see red columns in the screenshot below)

The red columns seem to show the same "Percentage actuals"

Am I doing something wrong?

 

New pbix file:

https://www.dropbox.com/s/myszmnvqg9m7u93/test2.pbix?dl=0