Forum Discussion
Filter across pages
Hi community, I have two visual pages. One with the year of invoices and another with the year of sales orders. I would like to filter, for example 2021 for invoices and this year should automat...
Please create a datatable, the simplest way is to use calendar function https://learn.microsoft.com/en-us/dax/calendar-function-dax
then create relationship to your invoice date and to your sales order date, then use that date column from new datatable.
olgad
Resident Rockstar
Resident RockstarPlease create a datatable, the simplest way is to use calendar function https://learn.microsoft.com/en-us/dax/calendar-function-dax
then create relationship to your invoice date and to your sales order date, then use that date column from new datatable.
It works 🙂
That is so a helpful idea. Thanks so much