Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Adding calculated row numbers to simple dataset

consider this basic table;   Customer Date CallID DesiredRowNumber A 20180109 45004 1 A 20180110 54596 2 A 20180111 45445 3 A 20180112 42231 4 A 20180112 52454 5...
Need Help
Show and Tell
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Please add an "Index" field in Power Query and then add the below logic as new column in Data pane.

     

    Rno = RANKX(FILTER(Test145RowNo,Test145RowNo[Customer]=EARLIER(Test145RowNo[Customer])),Test145RowNo[Index],,ASC,Dense)

     

     

     

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please add an "Index" field in Power Query and then add the below logic as new column in Data pane.

 

Rno = RANKX(FILTER(Test145RowNo,Test145RowNo[Customer]=EARLIER(Test145RowNo[Customer])),Test145RowNo[Index],,ASC,Dense)