Forum Discussion
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]...
Hi Anonymous ,
Has your problem been solved?
Please refer to my .pbix file.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
While you can make a dynamic table inside a measure, the Calendar table in your model is not dynamic. It only refreshes when you refresh the data model (not with slicer selections). Also, why not use CALENDAR(MIN(Table[DateColumn]), MAX(Table[SameorDifferentDateColumn])) ?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat