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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Hi All - relating to a similar scenario, I have the below table wherein  I want to RANK the 'SchedSTartTime' by each 'Resource' as shown in the 'desired result' column. Your help would be much appreciated. Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Write these measures

Start = SUM(Data[SchedStartTime])

Rank = RANKX(ALL(Data[Resource]),[Start])

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks very much. Since i needed the results urgently, I did the below to get to the desired outcome but thanks for your time. its apprecaited.

     

    1 - CONCATENATE(data[SaSchedDate].[Date],data[resource])

     

    2. RankSaBySchedDateTime = VAR d = Data[SaSchedDate]
    VAR a = Data[above concatenated field]
    RETURN
    CALCULATE (
    RANK.EQ ( d, Data[SaSchedDate], ASC ),
    FILTER ( ALL ( 'Data' ), data[above concatenated field] = a )
    )