Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi All,
I have multiple tables with dates and respective values on those dates. Since I could not create relationship among tables using date column, I was suggested to create dynamic calendar table to use that a date filter for multiple tables.
Filter is working fine but data shown in table after using filter has restricted data to just specific max. date and filter I put is for extended date.
Below is the example single table with the dynamic calendar table.
June 27 is the max date and we can see the value on June 27 when I have not applied filter in it
As soon as I apply filter of June 08 - June 27, I see data is only visible till June 20
Please assist in resolving this issue.
Thanks
Shivam
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 41 | |
| 30 | |
| 24 |