Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have a table as shown below.
All I want to do is, create a column which shows the difference of the parameters relative to the previous day for all units. Been browsing all over but didn't manage to find a solution. Thank you for your time
Solved! Go to Solution.
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
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?
Since 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 😞
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |