Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I am using EARLIER to get the expected results shown in the below picture ([last date value] red numbers).
I need the [solving day (original)] value to every row after the [solution] column was first changed to "Done". In this case, the "Solving day" was 2, since 2020.03.18 was the frist date that it was accepted as "done".
Currently I am using this DAX formula:
Solved! Go to Solution.
Hi @kormosb ,
We can use the following DAX formula to meet your requirement.
last date value =
VAR prevDate =
CALCULATE (
MIN ( 'Issue Navigator'[latest refresh date] ),
FILTER (
'Issue Navigator',
[Key] = EARLIER ( 'Issue Navigator'[Key] )
&& 'Issue Navigator'[Solution] = "Done"
)
)
RETURN
IF (
'Issue Navigator'[Solution] = BLANK (),
'Issue Navigator'[Solving day (original)],
CALCULATE (
MAX ( 'Issue Navigator'[Solving day (original)] ),
FILTER (
'Issue Navigator',
[Key] = EARLIER ( 'Issue Navigator'[Key] )
&& [Latest refresh date] = prevDate
)
)
)
The result like this,
By the way, PBIX file as attached.
Best regards,
Hi @kormosb ,
We can use the following DAX formula to meet your requirement.
last date value =
VAR prevDate =
CALCULATE (
MIN ( 'Issue Navigator'[latest refresh date] ),
FILTER (
'Issue Navigator',
[Key] = EARLIER ( 'Issue Navigator'[Key] )
&& 'Issue Navigator'[Solution] = "Done"
)
)
RETURN
IF (
'Issue Navigator'[Solution] = BLANK (),
'Issue Navigator'[Solving day (original)],
CALCULATE (
MAX ( 'Issue Navigator'[Solving day (original)] ),
FILTER (
'Issue Navigator',
[Key] = EARLIER ( 'Issue Navigator'[Key] )
&& [Latest refresh date] = prevDate
)
)
)
The result like this,
By the way, PBIX file as attached.
Best regards,
Thanks, it works!:)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |