Forum Discussion

sabd80's avatar
sabd80
Helper IV
2 years ago

Add row number

Hi,

I have below data, I would like to add the column row number as a measure to flag the row number based on the date per ID.

 

I cann't add a calculated column because it is live connection to a cube.

Can you help?

 

Need Help

4 Replies

    • manvishah17's avatar
      manvishah17
      Solution Supplier
      2 years ago

      plz check its performance time by performance analysis and make sure other measures are in optimize manner.

       

  • manvishah17's avatar
    manvishah17
    Solution Supplier
    2 years ago

    Hi sabd80 ,
    If you need to add a row number based on a date in a live connection to a cube in Power BI, you can achieve this by creating a measure.

     

     

    DateRankByID = 
VAR CurrentID = MAX(Sheet1[ID])
VAR CurrentDate = MAX(Sheet1[DATE])
RETURN
    RANKX(
        FILTER(
            ALL(Sheet1),
            Sheet1[ID] = CurrentID
        ),
        CALCULATE(MIN(Sheet1[DATE])),
        ,
        ASC,
        DENSE
    ) 

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!