Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
So I have a data set with people assigned with multiple dates. I am trying to pull the value(date) prior to. Ex. John has dates 10/12. 10/16 and 10/23 I want to pull the 10/16 date instead of the 10/23 date.
Can anyone help?
Solved! Go to Solution.
Hi @Zach5152 ,
Please try code as below.
Date Before =
VAR _ADDRANK =
ADDCOLUMNS (
'Table',
"Rank", RANKX ( FILTER ( 'Table', [Name] = EARLIER ( [Name] ) ), [Date],, DESC, DENSE )
)
RETURN
MAXX ( FILTER ( _ADDRANK, [Rank] = 2 ), [Date] )
My Sample:
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Zach5152 ,
Please try code as below.
Date Before =
VAR _ADDRANK =
ADDCOLUMNS (
'Table',
"Rank", RANKX ( FILTER ( 'Table', [Name] = EARLIER ( [Name] ) ), [Date],, DESC, DENSE )
)
RETURN
MAXX ( FILTER ( _ADDRANK, [Rank] = 2 ), [Date] )
My Sample:
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
could you share your pbix-file? Or create an example file which reproduces your issue?
User | Count |
---|---|
118 | |
66 | |
65 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |