Power BI Filter returns wrong Date Range

[Steffen1]

Hi Community, 

I have another problem with the Date / Time intelligence 

I have a Data Model with a custom date table which is defined as a date table. 

In options I disabled the auto date / time for this file and global.

In a visual I want to filter based on the Date column of my custom Date Table a relative date for this week.  

Now my problem: Today is Sunday 12.11.2023 and according to my custom date Table it would be week 45 starting Monday 06.11.2023 to Sunday 12.11.2023. ( blue frame 😞 

However, applying the filter he selects 12.11.2023 Sunday to Friday 18.11.2023 (green frame) : 

It seems the filter does not consider the week from my custom date table. 

I would be thankful for any idear why the filter choose the "wrong date" and if possible, how to change it ?

Best regards

[some_bih]

Hi @Steffen1 

as weeks are involved, details are important 🙂

please check your definition for weekday when it start, like is it Sunday or Monday

If you use WEEKNUM function please notice that different values could return different start of week, like 2 is Monday.

Check link for some details

https://learn.microsoft.com/en-us/dax/weeknum-function-dax?WT.mc_id=DP-MVP-4025372 

[Steffen1 · Accepted solution]

Hi some_bih, 

thank you for checking into this problem, 

my weekday starts on Mondays, as you can see in the column "Day of Week No for Sort " its 0 Monda - 6 Sunday. 

I did the Date Table within Power Query not with Dax.

Meanwhile I created a solution with the "offset-method":  https://www.youtube.com/watch?v=NKr2TizM-KU