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

Thanks Jai-Rathinavel but I cannot use your solution, I dont have a date to filter and I think my duplicates came from the links between tables... but I dont know what is the issue