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...
@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
amitchandak
Super User
Super User@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