DAX to summarize a table bringing only the last date of duplicate records.
Hi, I have "TABLE 1" where I have duplicate records, the issue is that while summarizing for getting unique records, as someone missepelled the name, I am getting two records for a single ID, as in case of ID 8 on my "Current Result" Table, this is incorrect.
The ideal would be to have something like the "DESIRED RESULT" table.
I need to used DAX as I do not have access to the data source for doing this from the Query.
DAX I am currently using, which is not working is: