Segmentation with more current default dates

[Anonymous]

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,

[amitchandak · Accepted solution]

@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