Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Generate a table based on slicer

Hi, I have a slicer with random dates, available on my sheet for the user to select a bunch of dates from the dropdown as shown below.   Based on the dates selected by the user, I want to c...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , A calculated table can not use a slicer value.

 

if you want to show 30 days trend based on selected value. Create slicer on 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 = _max -30
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