Forum Discussion

Nanap's avatar
Nanap
New Member
3 years ago

Extract fix value from Row with duplicate entries

Hi Experts,

 

I am working on data prep and i performed an outter join to get all the data i need for this report however there is a column that has duplicate data. deleting duplicates will not help in this scenario as i may loose other data. Is there a dax function i can write in order to just pick one values instead adding all the rows together. 

 

Thank you 

Data Protection
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    DAX function VALUES and DISTINCT are often used to retriece distinct values from a column. You may check if they fit in your case. 

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Nanap 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.