Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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 |
|---|---|
| 52 | |
| 35 | |
| 22 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 39 | |
| 21 | |
| 21 |