Forum Discussion

HEW's avatar
HEW
Icon for Helper III rankHelper 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
Icon for Solution Sage rankSolution 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.

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

I missed a bracket

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