The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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