Forum Discussion
Removing duplicate rows, data from different (joined) data sources
I have a report that's a combination SalesOrderHeaders and SalesOrderLines: Customer, Service Purchased, Invoice Date, Amount Due Boston College, Subscription for HE, 4/5/2020, $400 York Cit...
...or I have to build a named TABLE out of at least three database joins, filter it down and then jump over to the report view to finish the summary. Parking it for tonight - shouldn't be doing work today anyway 🙂
Anonymous , Try meaures like (with all measure you need on Min date
measure = calculate(max(Table[Invoice Date]), filter(Table,Table[Invoice Date] = calculate(Min(Table[Invoice Date]), allexpcept(Table,table[Invoice ID]))))
measure = calculate(max(Table[Amount Due]), filter(Table,Table[Invoice Date] = calculate(Min(Table[Invoice Date]), allexpcept(Table,table[Invoice ID]))))