Forum Discussion
Date slicer - different dates
Hi everybody, PowerBI newbie here. I have a table that includes customer transactions, including invoicenumber, invoice date and settlement date (if settled). Example: Invoice Invoice...
You can use date table . connect one of the date to the date table (active connection) and make the other inactive. You can use calculate(sum(amount)userelationship(invoicedate, datetable)
This should work