Dynamic segment date

[Anonymous]

Hello,

In my reports, I use a segment with the date to permit to users to change the date and analyse the period they need. But I would want that the date was automatically changed each morning where the dataset is refreshed.

For example, on 25/03/2023, the segment must be 01/01/2023 to 24/03/2023 ; on 26/03/2023,  the segment must be 01/01/2023 to 25/03/2023...

For this, I use a second segment with a filter on a "Default period" which is calculated in my calendar table. It works but it is not user friendly because the user has to change two segments to modify the date and the interaction between the two segments is not clear for all users.

Is there a better solution ?

Thanks

[Anonymous]

@amitchandak, thank you for your answer.

I'm sorry, I think that what I need wasn't enough clear. I hope it will be clearer with this example.

Here, it is what I do in order to have the results from 01/01/2023 to 28/03/2023 and to permit to the dashboard users to change the date and, for example, analyse 01 2022 to 12 2022 if they need. Tomorrow, the date will be 01/01/2023 to 29/03/2023 because my measure "Default Period" return "Yes" from the 1st day of the year to today()-1.

But, for the dashboard users, when they want to change the date, it is confusing to have to put"Period default = yes or no" and, after, to change the date. I would want to have only a segment with a date without a second segmet with "Default Period". Is it clearer ? Do you have a solution for this ?

[amitchandak]

@Anonymous , Try a measure like

QTD =
var _max = if(isfiltered('Date'),MAX( 'Date'[Date]) , today()) -1
var _min = eomonth(_max,-1* if( mod(Month(_max),3) =0,3,mod(Month(_max),3)))+1
return
CALCULATE([net] ,Filter('Date','Date'[Date]>= _min && 'Date'[Date] <= _max))