Forum Discussion
How to Create a unique identifier column based on the combination of two columns?
Hi Everyone, 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. We need to create ...
Anonymous , First add index column in power query and then try a new column in dax
ID=
countx(filter(Table, [Country] =earlier([country]) && [PG] =earlier([PG]) && [index] <=earlier([index]) ), [index])
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
amitchandak
Super User
Super UserAnonymous , First add index column in power query and then try a new column in dax
ID=
countx(filter(Table, [Country] =earlier([country]) && [PG] =earlier([PG]) && [index] <=earlier([index]) ), [index])
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi