Forum Discussion
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. ...
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
Jai-Rathinavel
Super User
Super UserAnonymous 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