Forum Discussion
It´s possible create a double filter?
Where is your calendar table???
You must use one and create relationships to forecast and sales and then use the year column from the calendar only as a slicer.
This will flow the filter from the calendar to forecast and sales tables.
Can you provide us sample data???
Oks, I was trying to attach a PBIX, but I don´t find where...
I´ll try to explain here...
I have two tables
One of forecast and another of sales. Each one have their own dates:
Then, I want to compare the sales with the forecast:
As you can see, I must select the year at the forecast and at the sales, because I can not create a unique column with all the dates.
I´d like send you the PBIX (somebody sent it to me once), but I don´n find where....
Where is your calendar table???
You must use one and create relationships to forecast and sales and then use the year column from the calendar only as a slicer.
This will flow the filter from the calendar to forecast and sales tables.