Forum Discussion
Solved
PowerBi Matrix Visual
Hi I have a powerbi repot that used a matrix visual that has rows Client name, Invoice number, and columns are Number of days overdue and lastly amount receivable.
The value column 'Days overdue by' is a measure that I have created from the invoice due date in my data set. The measure looks like:
Date_Diff = DATEDIFF(MAX(DebtorsDashboardView[duedate]),TODAY(),DAY)
The idea is when someone expands the matrix table, it'll then show the invoice number.
However, if a client has mulitple invoices due, and if the matrix visual is not expanded, then the row is picking the most recent invoice date value.
e.g:
Client A has invoices 1 that is 28 days over due Client A also has invoices 2 which is 15 days overdue.
The row totals are showing the 15 days over for client A. I'd like for it to show 28 days (the oldest invoice date that is)
Should the DATEDIFF() function be calculating the difference from the minimum due date, rather than the max?
2 Replies
Indeed it should have. Thanks Fthrs_Analytics !
Should the DATEDIFF() function be calculating the difference from the minimum due date, rather than the max?
