I’m trying to calculate the number of invoiced items for 10 weeks prior next to each other.
I’m using the following measure for all 10 weeks:
W1 = CALCULATE ( SalesInvoiceLines[Invoiced Quantity], DATESBETWEEN ( SalesInvoiceLines[InvoiceDate], MAX ( SalesInvoiceLines[InvoiceDate] ) - 6, MAX ( SalesInvoiceLines[InvoiceDate] ) ) )
The problem is that when i use a dates table linked to invoicedDate it shows blank when linked to Products and releasedProducts tables and if i use the salesInvoiceLines[invoiceDate] the table won’t load at all.
I can’t why both options aren’t working.
PS: same problem if i use FILTER instead of DATESBETWEEN