Forum Discussion
Solved
Duplicates, indexing
Hi All, I am trying to index a particular column based on re-occurance of same values (Region), can anyone please suggest solution for below I have following data sample Region Value A ...
Viraj16Agate , refer to this video from Curbal, that can help. But in this you might need an index column first
https://www.youtube.com/watch?v=7CqXdSEN2k4
In dax
countx(filter(Table, [region] = earlier([region]) && [Index] <= earlier([Index]) ), [Index])
You need to create index in power query
Viraj16Agate , refer to this video from Curbal, that can help. But in this you might need an index column first
https://www.youtube.com/watch?v=7CqXdSEN2k4
In dax
countx(filter(Table, [region] = earlier([region]) && [Index] <= earlier([Index]) ), [Index])
You need to create index in power query