Forum Discussion

Helper I

4 years ago

Date format

Hi all, I need the second column(Day of Reporting) to be changed as date column . Is there any possibility to change that?please help to sort it out.

Super User

4 years ago

Sujith12345 , do way to default date?

You need to create a column like this in date table and select and save

Date Type =
var _1 =TODAY()+-1*WEEKDAY(TODAY(),2)+1
return
SWITCH(TRUE(),'Date'[Date]=_1,"Last Monday",
,'Date'[Date]&"")