Forum Discussion
Cumulation other months
Hey Anonymous ,
thx for your reply.
I try to put my request into concrete terms:
The column "month" in my example comes from a Date table (Calender with hierarchy) in my model.
"Single value" is a calculated measure.
Do you need more information?
Many thanks!
// Base measure of which the accumulated value
// is a variation.
[Base Value] = SUM( FactTable[Value] )
[Accumulated Value] =
var __lastVisibleDate = max( Calendar[Date] )
var __result =
calculate(
[Base Measure],
Calendar[Date] <= __lastVisibleDate,
allselected( Calendar[Date] )
)
return
__result
Best
D
Hey Anonymous ,
thx for your reply.
I tried it and this was the result:
Any other ideas?
Stay healthy!
Hello again @all,
hope you're all well.
Unfortunately I still couldn't solve my problem.
Look at this table (all you can see here are measures):
My goal is to accumulate "Measure" in this table column by month. I've already tried the following (DAX formula by Anonymous😞
As I said the result is not what I'm looking for. The DAX formula is the right way to accumulate. I tried it and it works very well with other values. But in this case I've to try something different."Measure" is calculated like this:"Soll without adj" is calculated as follows:
I think here is the problem. Maybe the problem is due to the fact that it is viewed across several years?
Aside "AR Rest 2018" all other measures refer to 2019.
But this is necessary because Measure is a kind of target value related to the previous year.
Would it help if I add an example pbix.-file here?
Thank you again for your help!
Kind regards!
Cakos