How to Create a unique identifier column based on the combination of two columns?

Question

Hi Everyone,&nbsp;My requirement is to create a new identifier column based on the combination of the two existing columns.For Example, Let us consider this to be the Sample data.&nbsp;We need to create this ID (First column) based on the combination of "Country &amp; PG" column.&nbsp;IDCountryPGAreaAction1C1P1A1TRUE2C1P1A2FALSE1C1P2A1TRUE2C1P2A2TRUE3C1P2A3FALSE1C1P3A1TRUE1C2P1A1TRUE2C2P1A2FALSE&nbsp;We need to increment the ID, if the combination of the Country and PG is same. If one of them seems to change, then again we need to start from the index 1. Can anyone please help me in implementing this ID column. It would be really helpful If you could able to give me the solution file or M code.&nbsp;&nbsp;Thanks in advance!!&nbsp;

amitchandak · Accepted Answer

Anonymous , First add index column in power query and then try a new column in dax&nbsp; 
&nbsp;
ID=
countx(filter(Table, [Country] =earlier([country])&nbsp; &amp;&amp; [PG] =earlier([PG])&nbsp;&amp;&amp; [index] &lt;=earlier([index]) ), [index])
&nbsp;
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

Forum Discussion

How to Create a unique identifier column based on the combination of two columns?

2 Replies

Related content

Combine Column

Combining Column Data

Combine columns into 1

Tables combine

Identifying duplicates

ID	Country	PG	Area	Action
1	C1	P1	A1	TRUE
2	C1	P1	A2	FALSE
1	C1	P2	A1	TRUE
2	C1	P2	A2	TRUE
3	C1	P2	A3	FALSE
1	C1	P3	A1	TRUE
1	C2	P1	A1	TRUE
2	C2	P1	A2	FALSE