Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Checking for different values in duplicates

Good day all,   I have a table in Power Bi that looks similar to this: What I need to get is a column called Age_Check that would output 1 if for every group of records with the same name wh...
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Seem like missed age logic, Try this

     

    Age_check =
    var _1 = countx(filter(Table,table[Name] = earlier(Table[Name])),Table[Name])
    var _2 = countx(filter(Table,table[Name] = earlier(Table[Name]) && table[Age] = earlier(Table[age])),Table[Name])
    return
    if(_1 >1 && _1<> _2 ,1,0)

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , create a new column like

new column = if(countx(filter(Table,table[Name] = earlier(Table[Name])),Table[Name])>1,1,0)