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.
Looking for a way in Power BI to calculate the difference between values in the same column. Need the day over day change to the remaining duration. I have a formula that works but an issue has come up when durations are actually increased. I would prefer to not show negative change and the change be based off the original duration only. Please see existing formula and example data below.
Any help is greatly appreciated!
Solved! Go to Solution.
Hi @Daxtothemax ,
According to your description, here's my solution.
Create a measure.
Diff2 =
VAR _Diff =
CALCULATE (
MAX ( 'DS'[Hrs] ),
FILTER (
'DS',
'DS'[Task] = EARLIER ( 'DS'[Task] )
&& 'DS'[Date] = MINX ( ALL ( 'DS' ), 'DS'[Date] )
)
) - 'DS'[Hrs]
RETURN
IF ( _Diff < 0, 0, _Diff )
Get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Daxtothemax ,
According to your description, here's my solution.
Create a measure.
Diff2 =
VAR _Diff =
CALCULATE (
MAX ( 'DS'[Hrs] ),
FILTER (
'DS',
'DS'[Task] = EARLIER ( 'DS'[Task] )
&& 'DS'[Date] = MINX ( ALL ( 'DS' ), 'DS'[Date] )
)
) - 'DS'[Hrs]
RETURN
IF ( _Diff < 0, 0, _Diff )
Get the expected result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-yanjiang-msft thank you for this! It's getting closer. The only issue is that I need the difference between each date. So example below Task C should equal 8 comparing to the previous date. Any ideas on this?
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 |
---|---|
112 | |
97 | |
83 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |