Forum Discussion
Resolver IIISystem Date / between filter for 2 different years
Community SupportHi SpiroswayGR ,
Is your data model like this?
Based on this data model, when you filter the [System Date] field in the slicer, the date field in the calendar table is not changed, so the filter context in the measure formulas are not changed.
So you should add the date field of the calendar table to the slicer.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Resolver IIIv-lionel-msft thank you reply.
Well , model is almost same but with the difference of Sheet1.
Sheet1 should have Date that is connected with Calendar Date. Also System Date in Sheet1 that is Entry Date that information imported to the system.
Maybe should i change connection calendar date to sheet1 system date to work ?
- v-lionel-msft
Hi SpiroswayGR ,
Is your model like this?
You should add the dates in the fact table (Calendar table) to the slicer.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- SpiroswayGR
like this
Sheet1 = main table
- v-lionel-msft
Hi SpiroswayGR ,
The first method is to use the date field of the calendar table in the slicer, and the second method is to use the date field of the main table in the DAX formula.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.