Hi All,
Learnt few date functions in DAX
1 - To obtain Week Num = =WeekNum(DateColumn, 2)
2 - if you want day to start from Monday and 1 - if you want Sunday
2 - To obtain Month name
=Format(DateColumn,"MMM")
3 - To obtain Day name
=Format(DateColumn,"dddd")
No comments:
Post a Comment