Power BI Exchange

Expand all | Collapse all

Ranking Events by date by ID

  • 1.  Ranking Events by date by ID

    Posted 10 days ago
    Hello all,
    I need help with the dax for ranking events by date for a particular customer id ( CustomerTable). For instance if a customer contacts my shop 10 times i will like to rank the contact event id by date to the customer id:

    Event id      Rank    Date of Contact  Customer id
    00013         3           10/01/2018          0001
    00022        2             9/15/2018           0001
    00031        1             8/15/2018           0001

    This table has numberous customer IDs with several event id per customer id

    Thanks for the help in advance

    Regards,

    Arthur

    ------------------------------
    Arthur Obiadazie
    77084
    Houston TX
    6127097714
    ------------------------------


  • 2.  RE: Ranking Events by date by ID

    Posted 10 days ago

    Hello Arthur,

    I'm just begging to understand the scope of the RankX function in DAX, but I found a well explained blog about it.

    http://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

    How to use RANKX in DAX (Part 2 of 3 - Calculated Measures)

    How to use RANKX in DAX (Part 3 of 3 - The Finale)


    There is particular technique explained on how to use dates to rank rows.

    Best luck!


      



    ------------------------------
    Rosa Porras
    ------------------------------