Forum Discussion

Sab's avatar
Sab
Helper V
5 years ago

Create dynamic table based on the slicer selection

Hello,

 

I have a Date column having dates from the beginning of this year, to present day.

 

I need to create a dynamic temp table that will have dates from the firstdate in the Date column, to the selected date from the slicer, so if the selected value is Feb. 1st then the table will have 30 rows, if the selected value in slicer is 15 Feb, then the table would have 45 rows, etc.

 

Thanks

Need Help

4 Replies

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        5 years ago

        Hi Sab ,

         

        You cannot create a dynamic table at the model view, but you can create a dynamic table visual at the report view.

        First create an unrelated calendar table as slicer, and then create a measure applied to the table's visual level filter.

        Table 2 = DISTINCT('table1'[date])
        Measure = IF(MAX('table1'[date])<=MAX('Table 2'[date]),1)

         

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