Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
Lossing the Values BZ of inactive relationship in between the two relationships.
I have a cenario like 3 table Table 1 and Table 2 Table 3
in table 1 and table 2 havineing a two relation ships one is active another one is inacive.
and table 2 and table 3 having a relation ship one to many filet both direction.
I in my list of values in my slicer I can able to see the active reation ship values from the table3.
But I want list active and inactive values from the Table3.
Solved! Go to Solution.
Hi @Ajithrjaa
In a data model where the fact table contains multiple date fields like in your case (start date and end date for example) it is important to have your calendar table as a "disconnected table" with your fact tables. Having it as a disconnected table (with no relatinoship) will enable you to perform flexible duration analysis using both start date and end dates. Please have a look at the article below which discuss the use of disconnected calendar table in a headcount analysis which has similar start date and end date as your fact table data.
https://p3adaptive.com/finding-the-magic-part-2-on-the-way-to-data-happiness/
Best regards,
Hi @Ajithrjaa
In a data model where the fact table contains multiple date fields like in your case (start date and end date for example) it is important to have your calendar table as a "disconnected table" with your fact tables. Having it as a disconnected table (with no relatinoship) will enable you to perform flexible duration analysis using both start date and end dates. Please have a look at the article below which discuss the use of disconnected calendar table in a headcount analysis which has similar start date and end date as your fact table data.
https://p3adaptive.com/finding-the-magic-part-2-on-the-way-to-data-happiness/
Best regards,