date slicer as the end date, and display the value start from first day of the year of selected date

[Anonymous]

Hi, here is the situation that there is only one date slicer, which as the end date, and display the value start from first day of selected date

the data is like this

for example, the selected value is 20220401

so it should return value like this:

is there a solution to solve it?

[amitchandak · Accepted solution]

@Anonymous , Your slicer need to be an independent date table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -1*month(_max) ) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

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