Forum Discussion
Solved
Week start day monday
Hello guys, I need to check if the day is a weekend or not, knowing that the week should starting with Monday. And to do it, i used weekday function. But the result is not correct. I have tried al...
HI Rahma,
I check the system calendar and find the 1/7/2019 is Monday, the weekday function with option 2 in your table also get the correctly weekday number 1.(Monday to Sunday: 1~7) Why you say this function get the works with wrong result?
IsWeekend = IF ( WEEKDAY ( [Date], 2 ) > 5, 1, 0 )Regards,
Xiaoxin Sheng
HI Rahma,
I test the weekday function with option parameter 2 and it work as expected. What version of power bi desktop are you worked on? Can you please share a pbix that can reproduce the issue to test?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng