Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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
| User | Count |
|---|---|
| 23 | |
| 20 | |
| 19 | |
| 18 | |
| 10 |
| User | Count |
|---|---|
| 53 | |
| 53 | |
| 40 | |
| 37 | |
| 32 |