Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Fake duplicate in Table (link between 3 tables)

Hello,   I am struggling with my table and with what I call "fake duplicates". I have 3 tables that feed my pbi table (report) but I have seen multiple line where I am supposed to have only one.  ...
Need Help
  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    1 year ago

    Anonymous You can create a calculated column to filter only latest records. Use the belox DAX and apply "Yes" to the filter. This will filter only the latest record for each product name.

    Is Latest ? = 
var a = CALCULATE( MAX('Definition'[Last Change Date]), ALLEXCEPT('Sample','Sample'[Data Product Name]))
RETURN
IF('Definition'[Last Change Date] = a , "Yes", "No")

     

    Did I answer your question ? Please mark my post as a solution.

     

    Thanks,

    Jai

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Anonymous 

You can remove duplicates in a table in Power Query Editor before you load the data into Power BI. Select the column that defines a unique row and use the Remove Duplicates feature.

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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