Create the date range list based on date slicer selection

Anonymous , If you select a one date and want more than one date to display you need one independent date table

// Independent Date table - Date1 and Joined Table Date - MTD
measure =
var _max = maxx(allselected('Date1'),'Date1'[Date]) //
var _min = eomonth(_max,-1) +1
return
CALCULATE(SUM(Sales[Sales Amount]),filter(Date, Date[Date]>=_min && Date[Date] <=_max ))

refer if needed

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Hi Anonymous ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.