Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Need help in tweaking this DAX to accomodate one more date - Sent Date.
So it should rank dynamically based on Submit date as well as Sent date
RANK3 = RANKX (
FILTER ( ALLSELECTED (Table1), Table1[FullName] = SELECTEDVALUE ( Table1[FullName] ) ),
CALCULATE ( SELECTEDVALUE ( Table1[SubmitDate] )),,DESC,DENSE )
Thanks
Solved! Go to Solution.
HI @Anonymous ,
Do you mean rank by multiple columns? If this is a case, I'd like to suggest you use ISONORAFTER function:
RANK3 =
COUNTROWS (
FILTER (
ALLSELECTED ( Table1 ),
Table1[FullName] = SELECTEDVALUE ( Table1[FullName] )
&& ISONORAFTER (
Table[SubmitDate], MAX ( Table[SubmitDate] ), ASC,
Table[SentDate], MAX ( Table[SentDate] ), ASC
)
)
)
Reference link:
Regards,
Xiaoxin Sheng
HI @Anonymous ,
Do you mean rank by multiple columns? If this is a case, I'd like to suggest you use ISONORAFTER function:
RANK3 =
COUNTROWS (
FILTER (
ALLSELECTED ( Table1 ),
Table1[FullName] = SELECTEDVALUE ( Table1[FullName] )
&& ISONORAFTER (
Table[SubmitDate], MAX ( Table[SubmitDate] ), ASC,
Table[SentDate], MAX ( Table[SentDate] ), ASC
)
)
)
Reference link:
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
if your data is not confidential please share the sample data and expected output.
Best Regards,
Mail2inba4
User | Count |
---|---|
94 | |
79 | |
74 | |
63 | |
60 |
User | Count |
---|---|
110 | |
101 | |
84 | |
64 | |
62 |