topic Extra filters on date table don't work with time intelligence functions. in DAX Commands and Tips

Extra filters on date table don't work with time intelligence functions.

Riksall — Thu, 17 Jul 2025 21:13:06 GMT

Hello,

it seems that setting extra filters (in the filter pane or in the CALCULATE) causes unexpected results (for me!) when using time intelligence functions like DATESYTD.

For instance :

CALCULATE([sales],

DATESYTD('Date'[Date]))

When filtering on "day of week" from the date table gives unexpected results.

Can anyone give a sort of theoretical solution why this is happening?

Thanks!

Re: Extra filters on date table don't work with time intelligence functions.

lbendlin — Thu, 17 Jul 2025 22:03:56 GMT

Can you describe what "unexpected" means? What is the expected outcome?

Re: Extra filters on date table don't work with time intelligence functions.

v-lgarikapat — Fri, 18 Jul 2025 12:14:51 GMT

Hi Riksall ,

Could you please provide more details about the issue you're experiencing with the 'Day of Week' column in the date table returning unexpected results? This will help me better understand the problem and suggest an appropriate solution.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

We look forward to hearing from you.

Best Regards,

Lakshmi

Re: Extra filters on date table don't work with time intelligence functions.

v-lgarikapat — Mon, 21 Jul 2025 10:41:18 GMT

Hi Riksall

Avoid filtering the date table directly with non contiguous attributes like day names when using time intelligence.

Instead, use measures that calculate over valid date ranges and apply filters to the fact table or post aggregation.

Time intelligence functions (DAX) - DAX | Microsoft Learn

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out — we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi

Re: Extra filters on date table don't work with time intelligence functions.

v-lgarikapat — Thu, 24 Jul 2025 10:23:42 GMT

Hi Riksall ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

Re: Extra filters on date table don't work with time intelligence functions.

v-lgarikapat — Mon, 28 Jul 2025 07:09:10 GMT

Hi Riksall ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

Re: Extra filters on date table don't work with time intelligence functions.

v-lgarikapat — Thu, 31 Jul 2025 09:53:44 GMT

Hi Riksall ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

Re: Extra filters on date table don't work with time intelligence functions.

johnt75 — Thu, 31 Jul 2025 10:10:24 GMT

SQLBI has an article about exactly this - https://www.sqlbi.com/articles/filtering-weekdays-in-dax/

Re: Extra filters on date table don't work with time intelligence functions.

Riksall — Thu, 31 Jul 2025 10:17:19 GMT

Thanks for the link! accepted as solution.