DAX: Remove Duplicates based on Max date of column from a Union table
For technical reasons and general difficulty dealing with SAP BW as a datasource, I have a table modeled as a DAX UNION statement that glues together about 10 tables. That resulting table has duplicates and I'd like to keep the one with the most recent date. In Power Query, it is a straight forward "Group By", but it is not obvious in DAX
How can I achieve keeping rows based on an ID and where the date = the Max Date of that ID in DAX?
Can't do this. Each of the tables are separate in M/Power Query. The final table is made in DAX with a Union statement. Doing this would eliminate duplicates withing individual talbes bu tnot across all tables