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 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

FWIW, creating a measure:

 

LatestDate =
IF(
COUNTROWS(FILTER(FreeTextInvoiceHeaders, FreeTextInvoiceHeaders[InvoiceDate] >=EARLIER( FreeTextInvoiceHeaders[InvoiceDate]) && FreeTextInvoiceHeaders[CustomerAccount] = EARLIER(FreeTextInvoiceHeaders[CustomerAccount]))) = 1, 1, 0)
 
results in:
 
EARLIER/EARLIEST refers to an earlier row context which doesn't exist.
 
Will do some more digging...