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"
                    )
rocky09's avatar
rocky09
Solution Sage
9 years ago

Phil_SeamarkJust out of curiosity, where can I find DAX complex examples to play? I have referred your answers to many threads, most of them out from DAX solutions. Can you please kindly provide some inputs, how I will be mastered with DAX.

 

Any reference links? Any Books?

 

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi rocky09

     

    I reckon the best source of complex examples to play with are here in the community.  There is a good variety in the types of problems posted and remember not every accepted answer is necessarily the best.  Take a few problems and look to see what other solutions you can come up with.  

     

    Other than that, I think Sean recommended the Definitive Guide to DAX the other day, and if he recommends it, it's probably pretty good.