How to get Relative Date filter to recognize Monday as start of week

[Anonymous]

I have researched this topic and made changes to my mquery in the advanced editor and still nothing changes. 

My intent is to have my dates in fact tables, and the date table itself of course, recognize Monday as the start of the week.   However, nothing I am doing seems to be working.   The dates still show up with Sunday (here in the US) as the start of the week.   

This date below for example, which is connected to my date table, shows Sunday if I select "this week" in the relative date filter.  

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Unfortunately, the current version cannot realize this idea, please submit your idea.

https://ideas.powerbi.com/ideas/ 

You can try other ways to achieve it. Create two calculated columns:

Weeknum = WEEKNUM( 'RMA Date'[Date] , 2 )

Column 2 = 
IF(
    'RMA Date'[Weeknum] = MAX('RMA Date'[Weeknum]),
    "Current Week",
    "Last " & (MAX('RMA Date'[Weeknum])-'RMA Date'[Weeknum]) & " Week"
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fcoatis]

@Anonymous go to file options, options and settings, and change your regional settings to an idiom you know the week beggins on monday (brazilian portuguese) in my case.

hope this helps

[Anonymous]

Doesn't that just change things like the date format?   I'm not sure it affects the date table time calculations.

[Fcoatis]

Yeah, just checked that it doesnt affect relative filter. Sorry