Week day DAX

[Anonymous]

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 · Accepted solution]

@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