Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    ...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 🙂

AllisonKennedy's avatar
AllisonKennedy
Community Champion
5 years ago

Anonymous 

 

What are the raw tables before the joins merge, etc? 

 

Otherwise if the data you pasted above is all in one table, you could add a column that flags the latest date: 

 

LatestDate =
IF(
COUNTROWS(FILTER('Table', 'Table'[Invoice Date] >=EARLIER('Table'[Invoice Date]) && 'Table'[Customer] = EARLIER('Table'[Customer]))) = 1, 1, 0)