Forum Discussion

matrix_user's avatar
matrix_user
Helper III
4 years ago
Solved

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 calcula...
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

amitchandak's avatar
amitchandak
Super User
4 years ago

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