Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power query- Key Number for the records

Hi All, I need to give number for each record of ACE_VALUE column I have concatenated 3 columns and created AC_VALUE column and i want to see key number like below example in a newly created cust...
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi Anonymous 
    You can duplicate the table and remove duplicates :

    Add an index column :

    And merge the tables:

    The table that merged can be unchecked from loading to the model

    pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Shreeram04's avatar
Shreeram04
Resolver III
2 years ago

Hi Anonymous ,

 

Please refer to the screenshot below and measure.

 

Key Number1 =
RANKX(
    VALUES('Table'[ACE_VALUE]),
    'Table'[ACE_VALUE],
    ,
    ASC,
    Dense
)


If this post helps, please consider accept as solution to help other members find it more quickly.

 

Thanks,

Hari R

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Shreeram04 Thanks for replying
    How to do it in power query
    I am doing all transformations in Dataflows so I need to add custom column in power query
    Can you help me with taht please

    Thanks a lot