Forum Discussion

hengsworld's avatar
hengsworld
Frequent Visitor
9 years ago

remove duplicates names

Hello Everyone,    I been stuck on this problem for a bit now and reaching our for some help :)    I am looking to remove duplicate names for example    UsersName | Is-WindowFoundationReady  B...
Need Help
Sean's avatar
Sean
Community Champion
9 years ago

Phil_Seamark  nice touch with the IN operator! :smileyhappy:

so basically the above is equivalent to...

 

New Table ALT =
SUMMARIZE (
    FILTER (
        'Table',
        'Table'[Office] = "Office 365"
            || 'Table'[Office] = "Office 2016"
    ),
    'Table'[User Name],
    "Is-WindowsFoundationReady", "Foundation Ready"
)

 

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

I think the challenge there is that Bob will appear twice with two states (ready and not ready).  Bit that is just my interpretation, which can be miles off :)