Hi @Anonymous
I gave you some erroneous code previously (I hadn't tested it - i was making extrapolations from other similar work I've done, but I had some false assumptions).
Points 1-3 in the above reply still hold - please review them. However, now we need to modify the measures.
For transparency, we'll use 3 measures. I'll talk about where they can be combined afterwards
TodaysValue=
SWITCH(
[MType];
"BJ-HÖ1"; AVERAGE(Blad1[BJ-HÖ1]);
"BJ-MÄ"; AVERAGE(Blad1[BJ-MÄ]);
"BJ-TS1"; AVERAGE(Blad1[BJ-TS1]);
etc
)
PrevDayValue = CALCULATE([TodaysValue]; PREVIOUSDAY(DateTimeTab[Date]))
Measure Delta = [TodaysValue] - [PrevDayValue]The mistake was thinking we could store some of the complex code in variables and use the code again further down in the measure. I think we can really only have a minimum of 2 measures, unless you want to replicate a lot of code:
TodaysValue=
SWITCH(
[MType];
"BJ-HÖ1"; AVERAGE(Blad1[BJ-HÖ1]);
"BJ-MÄ"; AVERAGE(Blad1[BJ-MÄ]);
"BJ-TS1"; AVERAGE(Blad1[BJ-TS1]);
etc
)
Measure Delta =
//NOTE That variables are not needed here - just showing for illustrative purposes
VAR __Todaysvalue = [TodaysValue]
VAR __PrevValue = CALCULATE([TodaysValue], PREVIOUSDAY(DateTimeTab[Date])
RETURN __Todaysvalue - __PrevValue
//You could do the following without any variables and get the same results
//Measure Delta = [TodaysValue] - CALCULATE([TodaysValue], PREVIOUSDAY(DateTimeTab[Date])Hope this finally gets you to where you need to be. Sorry for the earlier confusion.
David
