Add row number

[sabd80]

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?

[sabd80]

Thanks @manvishah17 , it worked but it is very slow.

[manvishah17]

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

[sabd80]

Hi @manvishah17 , there are not any other measures.

[manvishah17]

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!