Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
What is the "EOD"?Do dates change dynamically? Or a fixed week or month?
How-to-Get-Your-Question-Answered-Quickly
@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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 158 | |
| 132 | |
| 116 | |
| 79 | |
| 54 |