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 🙂
Found a video that explained everything succinctly, suggesting:
Last Date =
VAR CurrentName = CustomersV3[OrganizationName]
RETURN
MAXX(
FILTER( ALL( CustomersV3 ), CustomersV3[OrganizationName] = CurrentName),
FreeTextInvoiceHeaders[InvoiceDate])
However, i'm back to having it fail with:
A single value for column 'InvoiceDate' in table 'FreeTextInvoiceHeaders' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
However, i'm back to having it fail with:
A single value for column 'InvoiceDate' in table 'FreeTextInvoiceHeaders' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Examples seem to consider that you have a single table in front of you of source data, not a view of filtered database joins - unless PowerBI has a table name that reflects what you can see in front of you as a report.
Frustration continues. In the meantime, the YouTube video that looks so close is: Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI - YouTube
Frustration continues. In the meantime, the YouTube video that looks so close is: Calculate The Last Or Max Value Within A Table Of Data Using DAX In Power BI - YouTube
...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 🙂