Formatting a WEEKDAY expression.

[matrix_user]

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.

[amitchandak · Accepted solution]

@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