Forum Discussion

i820017's avatar
i820017
Resolver II
4 years ago
Solved

Date to YearMonth Column

I am trying to create a column that takes a date in mm/dd/yyyy and turns it into YearMonth. (The name of the column that I am working with is 'Procedure Request Form'[Date Request Submitted])   For...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    oh....!!! This should work now. 🙂

    Column = IF(ISBLANK('Table'[Column1]),BLANK(),FORMAT(DATEVALUE('Table'[Column1]),"YYYYMM"))