Forum Discussion
Formular for Delta-value - Opposite to ´EARLIER´
Hi,
How would I design the calculation to have the same results - but displayed at the RED ARROW instead of at the RED BOX?
Current code:
Delta Data =
'4_DataLog'[Data] -
CALCULATE(
SUM('4_DataLog'[Data]) , FILTER('4_Datalog' , '4_DataLog'[Indeks.1]
= EARLIER('4_DataLog'[Indeks])))
Hi, Anonymous
According to your description and picture, I guess you want to make each value of [Delta Data] move to the last row of this column, you can try this measure:
Delta Data = var _nextvalue= CALCULATE(SUM('4_DataLog'[Data]),FILTER('4_DataLog',[Indeks]=EARLIER('4_DataLog'[Indeks.1]))) var _data= _nextvalue-[Data] return IF(_nextvalue=BLANK(),BLANK(),_data)And you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- v-robertq-msft
Community Support
Hi, Anonymous
According to your description and picture, I guess you want to make each value of [Delta Data] move to the last row of this column, you can try this measure:
Delta Data = var _nextvalue= CALCULATE(SUM('4_DataLog'[Data]),FILTER('4_DataLog',[Indeks]=EARLIER('4_DataLog'[Indeks.1]))) var _data= _nextvalue-[Data] return IF(_nextvalue=BLANK(),BLANK(),_data)And you can get what you want, like this:
You can download my test pbix file here
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
