Forum Discussion

Vijay08V's avatar
Vijay08V
Icon for Helper III rankHelper III
4 years ago
Solved

DAX to find duplicate IDs with different Names

Hi,   I am trying to create a table which would give me IDs that has been tagged to different names and it needs to exclude any blank rows or repition of same name. Table :                        ...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Vijay08V 

    You can create new table

     

    NewTable =
SUMMARIZE (
    FILTER ( OldTable, OldTable[Name] <> BLANK ( ) ),
    OldTable[ID],
    OldTable[Name]
)

     

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Vijay08V 

You can create new table

 

NewTable =
SUMMARIZE (
    FILTER ( OldTable, OldTable[Name] <> BLANK ( ) ),
    OldTable[ID],
    OldTable[Name]
)

 

Vijay08V's avatar
Vijay08V
Icon for Helper III rankHelper III
4 years ago

tamerj1  Thank you tamerj1. It worked