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 explanation on this dax..
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
1 Reply
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