Forum Discussion

Viraj16Agate's avatar
Viraj16Agate
Regular Visitor
4 years ago
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  ...
Duplicates
indexing
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

     

     

Fowmy's avatar
Fowmy
Super User
4 years ago

Viraj16Agate 

You can first add an index column in Power Query or in the source then add the following column to your table in the model:

Column = 
COUNTROWS(
    FILTER( Table4 , Table4[Region] = EARLIER(Table4[Region]) && Table4[Value] = EARLIER(Table4[Value]) && Table4[Index]  <= EARLIER(Table4[Index] ))
)