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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

This table will give you a distinct list of users who have at least one record where they are Foundation Ready according to what I think your rules are.

 

Let me know what you think

 

New Table = SUMMARIZE(
                 FILTER(
                    'Table',
                    'Table'[Office] IN {"Office 365","Office 2016"}
                    ),
                    'Table'[User Name] , 
                    "Is-WindowsFoundationReady" , "Foundation Ready"
                    )
hengsworld's avatar
hengsworld
Frequent Visitor
9 years ago

Hi Phil, when I tried to implement the new table it is giving me this error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." 

 

 

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    • hengsworld's avatar
      hengsworld
      Frequent Visitor
      9 years ago

      I see, thank you! Phil_Seamarkhow can I also provide users that are not foundation ready?