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

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 )
)