Forum Discussion
Cumulative total
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])))
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
Hi,
I have not been able to solve the problem. I get the correct answer only when i select Q1 in the chicklet slicer. May be someone else can help you from here. You may download the PBI file from here.
Hi
The reason that Q2, Q3 and Q4 doesn't work probably has to do with that the budget is all in Q1 on date 01/01/20XX and DATESBETWEEN can't see the budget in Q1 if you select Q2, Q3 or Q4 so it can't calculate the percentage.
Thanks for thinking with me and trying to make up a solution. We probably need something else then DATESBETWEEN.
Is there anyone else who thinks to know how a cumulative % can be calculated only after a selected period?
I would really really really be grateful for any help!
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?