Forum Discussion

HEW's avatar
HEW
Helper III
4 years ago

Calculate deviation% based on first available value

Hi.   I am trying to calculate the deviation% from the first available value compared to the last available value in selected period.   As you can tell from below matrix, the first row in the mat...
Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

Try using FIRSTNONBLANKVALUE & LASTNONBLANKVALUE for the data you are comparing e.g.

 First Value = FIRSTNONBLANKVALUE(DimDate[FullDate, MIN('Historic_Gross_price'[Gyldig fra]))

                                                                                            MAX (above I'm not sure of your table-field name after MIN

                                                                                            AVG

all should work and your time slicer will get these starting - ending values and then you can do your comparisons from here. I hope that helps.

HEW's avatar
HEW
Helper III
4 years ago

Whitewater100  thank you for taking the time to reply.

 

I would like the date slicer to be flexible and it should not adjust according to the starting dates. If, for example, I select year 2020, I would like the cost prices for the first date of every month shown in the matrix - and the deviation % should be calculated based on the prices. If the first price is in May 2020 (article not purchased earlier) this should be the first value.

 

Do you follow me? It is a bit difficult to explain 🙂