Forum Discussion
Week day DAX
WeekDay = ExecutionLog2[TimeStart]-WEEKDAY(ExecutionLog2[TimeStart],2)+1 I found this dax for date start form monday for respective date (Timestart) its works correctly but could any one give expla...
Anonymous,
In your formula, WEEKDAY(ExecutionLog2[TimeStart],2) part returns week number of ExecutionLog2[TimeStart] date, and the week number of Monday is 1, thus the whole DAX will return Monday of the week that ExecutionLog2[TimeStart] date resides in. There is an example for your reference.
Regards,
Lydia
Anonymous,
In your formula, WEEKDAY(ExecutionLog2[TimeStart],2) part returns week number of ExecutionLog2[TimeStart] date, and the week number of Monday is 1, thus the whole DAX will return Monday of the week that ExecutionLog2[TimeStart] date resides in. There is an example for your reference.
Regards,
Lydia