Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create dynamic table based on dropdown filter choice

Hi,  I'm trying to create a dynamic table as a data source in my report using CALENDAR() function. I'm using this function:    CALENDAR(DATE(YEAR([start_date]),month([start_date]),day([start_date]...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi v-lionel-msft 

     

    Thanks for this solution, but my date table (which is used to calculate date measures) is in this format: 

     

    Period                         Start Date            End Date

    Last Week                 13th July,2020      19th July,2020

    Last Month                1st Jun,2020         30th Jun,2020

     

    There is no date column which can be used to create direct relationship between this and the dynamic table.