Home
About Us
Ask Question
All Products
Blog
Services
Online Job Support
Online Courses
File Share
Loyalty
More
how to get this ' floor(weekend (today())))' in DAX
WeekendCheck =
VAR CurrentDay = WEEKDAY(TODAY(), 2) -- This starts the week on Monday (1) and ends on Sunday (7)
RETURN
IF(CurrentDay = 6 || CurrentDay = 7, 1, 0) -- Return 1 for Saturday or Sunday, otherwise 0
This formula will return 1 if today is a weekend (Saturday or Sunday) and 0 otherwise.
WeekendCheck =
VAR CurrentDay = WEEKDAY(TODAY(), 2) -- This starts the week on Monday (1) and ends on Sunday (7)
RETURN
IF(CurrentDay = 6 || CurrentDay = 7, 1, 0) -- Return 1 for Saturday or Sunday, otherwise 0
This formula will return 1 if today is a weekend (Saturday or Sunday) and 0 otherwise.