Forum Discussion
Data Modelling Doubt
I want the doc to be added in the table visual based on the take over and handover date in the main table. Could someone please assist me with this and provide guidance on the ...
Hi v-xuxinyi-msf,
Thanks for the effort!!!
Point 1:
kindly find my corrected Calendar table below
It contains all date from 2023 to 2024.
Point 2:
It looks like you've created a separate table named "Query 1" in Power BI, but my actual requirement isn't to have a physical table. Instead, I need the data to be displayed only within the table visual. I also wonder whether it's necessary to have another bridge table for DOC, similar to the one for IMO. I tried creating it, but it didn't work as expected to filter document names based on takeover and handover dates.
I've been trying to resolve this for quite some time but still haven't achieved the desired outcome. I would really appreciate your help.
Regards,
S. Madhan