Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
@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
Doesn't that just change things like the date format? I'm not sure it affects the date table time calculations.
Yeah, just checked that it doesnt affect relative filter. Sorry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |