Create a value / ID from a combination of 2 column for unique combination

[jeffrock]

Hi power bi community,

I have a scenario in the below table

Category	Type	Needed ID
Bus	small	1
bus	small	1
car	medium	2
car	big	3
bike	big	4
bike	big	4
tempo	medium	5
bike	small	6

I need to create a column Needed ID based on the combination of first two column.

if the combination is same assign same number or else different.

I just need to assign any number which should be same for same combination and different for unique combination

Appreciate your help

Thank you

[amitchandak · Accepted solution]

@jeffrock , Create a column rank and try

new column=

Rankx(Table, [Categoty] & "-" & [Type] ,,asc,dense)

or

new column=

Rankx(Table, calculate([Categoty] & "-" & [Type] ) ,,asc,dense)