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

[Riksall]

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!

[v-lgarikapat]

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

[v-lgarikapat]

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

[lbendlin]

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