Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have 4 fact tables.
1. Accounting actuals
2. Budget
3. Outlook
4. Previous Outlook
The only fact table that has a defined date is accounting actuals, the rest only show data by month (name and #), there is no year, day or date. I am having trouble building a relationship as I want to compare tables (1vs2, 1vs3 and 3vs4). I want to add a slicer by month, but it only slices the accounting actuals data. I created a date table that has Date, days in month, start of month, end of month, month name, month #, Year and YYYYMM. How can I use the date table to slice fact tables 2-4 when Period name or number is not unique as it wont let me create a many to many relationship as it will create ambiguity between the other relationships I have.
Solved! Go to Solution.
Hi,
In the Accounting Actuals table, create a calculated column to extract Month name. Do not create any relationships between the 4 tables. Create a Month table with 12 rows. Create a relationship (Many to One and Single) from the Month name column of each of the 4 fact tables to the Month table.
Hope this helps.
Hi,
In the Accounting Actuals table, create a calculated column to extract Month name. Do not create any relationships between the 4 tables. Create a Month table with 12 rows. Create a relationship (Many to One and Single) from the Month name column of each of the 4 fact tables to the Month table.
Hope this helps.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
104 | |
71 | |
70 |