Forum Discussion
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...
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"
)
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"
)
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 :)