Forum Discussion
Segmentation with more current default dates
Hello
I need to update the default date of a date targeting.
The report that contains the last 30 days of data and has automatic update, it does not allow thousand-day selections (you can only see one day at a time) and I need it always marked the most current day for segmentation.
If anyone can help me I thank you very much!
A greeting,
@nvchristiano , You can create a column like this in your date table like these
Es Hoy : if('Date'[Date]-TODAY(),"Today",[Date]&"")
Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-TODAY(),"Today",'Date'[Date]-TODAY()-1,"Yesterday",'Date'[Date]&"")
sort on date and select Today and Save
1 Reply
@nvchristiano , You can create a column like this in your date table like these
Es Hoy : if('Date'[Date]-TODAY(),"Today",[Date]&"")
Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-TODAY(),"Today",'Date'[Date]-TODAY()-1,"Yesterday",'Date'[Date]&"")
sort on date and select Today and Save