Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rank by Date & Time

Hello,    I have a dataset that I am currently ranking by Date, which is working well. However, I have multiple entries for the same day, so I would like it to assign a rank by looking at both the ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    You just need to remove ".[Date]".

    Rank =
VAR d = EventSignatures[DateSigned]
VAR a = EventSignatures[ActiveForm_ld]
RETURN
    CALCULATE (
        RANK.EQ ( d, EventSignatures[DateSigned], ASC ),
        FILTER ( ALL ( 'EventSignatures' ), EventSignatures[ActiveForm_ld] = a )
    )

    Rank-by-Date-Time

     

    Best Regards,
    Dale

Fraz707's avatar
Fraz707
Helper I
6 years ago

Can you tell what modification can we do on this so that the ranking is done taking in acoount the seconds also?, as i tried the mentioned DAX and its working fine till minutes but if two records are only varying by seconds then this query ranks both of them equally. Attached a screen shot for reference, left side is the date and right side is the rank.

 

Thanks.

 

v-jiascu-msft