Forum Discussion
Formatting a WEEKDAY expression.
I have calculated column for start date of the week: StartWeekMon = 'DateDIM'[DATE]-WEEKDAY('DateDIM'[DATE],2)+1
It is in text type format.
I am looking for ideas on how to format the calculated colum so I can chage the results to DD/MMM/YY or DD/MM/YYYY, DDDD/MM/YY or any other ways I desire.
Thank you.
matrix_user , This formula should return date only
'DateDIM'[DATE]-WEEKDAY('DateDIM'[DATE],2)+1
Unless you have used & additionally like
('DateDIM'[DATE]-WEEKDAY('DateDIM'[DATE],2)+1 ) & ""
Change the data type to date and use format option under column tools to get a format or type is there DD/MM/YYYY
1 Reply
matrix_user , This formula should return date only
'DateDIM'[DATE]-WEEKDAY('DateDIM'[DATE],2)+1
Unless you have used & additionally like
('DateDIM'[DATE]-WEEKDAY('DateDIM'[DATE],2)+1 ) & ""
Change the data type to date and use format option under column tools to get a format or type is there DD/MM/YYYY