Forum Discussion

jpcbr's avatar
jpcbr
Regular Visitor
9 years ago
Solved

Detecting duplicates by validating two column

Hello :)   Im new at power bi, so im sorry for the noob question :P   So i have a table more or less like this   Company Stage microsoft MAL asus MQL toshiba SAL lg MAL a...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    jpcbr,

     

    Please refer to the steps below to achieve your requirement.

    1. Add a index column.(Edit Query)
    2. Create a column to combine company and stage column.
      CompanyStage = Table1[Comapny]&Table1[Stage]
    3. Create your expected column.
      outputcolumn = IF(RANKX(FILTER(Table1,Table1[CompanyStage]=EARLIER(Table1[CompanyStage])),Table1[Index],,ASC)>1,BLANK(),Table1[Stage])

    Regards,

    Charlie Liao

v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

jpcbr,

 

Please refer to the steps below to achieve your requirement.

  1. Add a index column.(Edit Query)
  2. Create a column to combine company and stage column.
    CompanyStage = Table1[Comapny]&Table1[Stage]
  3. Create your expected column.
    outputcolumn = IF(RANKX(FILTER(Table1,Table1[CompanyStage]=EARLIER(Table1[CompanyStage])),Table1[Index],,ASC)>1,BLANK(),Table1[Stage])

Regards,

Charlie Liao

jpcbr's avatar
jpcbr
Regular Visitor
9 years ago

Thats very well thought!!! Thanks a lot :D