Forum Discussion
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.
2 Replies
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]&"")Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35
What is the "EOD"?Do dates change dynamically? Or a fixed week or month?
How-to-Get-Your-Question-Answered-Quickly
