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 create a table which has a list of dates 30 days prior to the selected date.
For example if I select 16 Dec 2022 and 04 January 2023 on the dropdown, I want my table to have all the dates between 16/11/2022-15/12/2022 and 04/01/2023-03/02/2023. This should update when the user selects a different date.

Is this possible? Thanks in advance!

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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