Forum Discussion
Finding the value difference between dates
maybe Johnt75 forgot to -1 for CurrentDate. like:
Diff to prev day =
VAR CurrentDate = 'Table'[Date]
VAR CurrentUnit = 'Table'[Unit]
VAR CurrentValue = 'Table'[Parameter]
VAR PrevValue =
LOOKUPVALUE (
'Table'[Parameter],
'Table'[Date], CurrentDate-1,
'Table'[Unit], CurrentUnit,
0
)
RETURN
CurrentValue - PrevValue
You could add a column like
Diff to prev day =
VAR CurrentDate = 'Table'[Date]
VAR CurrentUnit = 'Table'[Unit]
VAR CurrentValue = 'Table'[Parameter]
VAR PrevValue =
LOOKUPVALUE (
'Table'[Parameter],
'Table'[Date], CurrentDate,
'Table'[Unit], CurrentUnit,
0
)
RETURN
CurrentValue - PrevValue
Thank you for your answer but it doesn't work since the assigned value for the PrevValue is same as the Current Value. Hence, the returning value is always 0. I think we should change the date in the lookupvale part to previousday, but I do not know how.
johnt75 I created another column using NEXTDAY and assigned the date in lookupvalue to the created NEXTDAY. That way I fixed it. Thank you
maybe Johnt75 forgot to -1 for CurrentDate. like:
Diff to prev day =
VAR CurrentDate = 'Table'[Date]
VAR CurrentUnit = 'Table'[Unit]
VAR CurrentValue = 'Table'[Parameter]
VAR PrevValue =
LOOKUPVALUE (
'Table'[Parameter],
'Table'[Date], CurrentDate-1,
'Table'[Unit], CurrentUnit,
0
)
RETURN
CurrentValue - PrevValue
hi Anonymous
something like this shall also work, right?
Diff to prev day =VAR CurrentDate = 'Table'[Date]VAR CurrentUnit = 'Table'[Unit]VAR CurrentValue = 'Table'[Parameter]VAR PrevValue =MINX (FILTER('Table','Table'[Unit]=CurrentUnit&&'Table'[Date]=CurrentDate-1),'Table'[Parameter]RETURNCurrentValue - PrevValueSince I am new to Power BI I can't tell if this should work or not, but when I tried it for my model it didn't 😞