Power BI Bridge Table Setup
Budget: $10 – $30 USD
I need a straightforward bridge table added to my Power BI data model so the Sales table (many rows) connects cleanly to a Fact table (single row per entity). The Fact table already contains both a primary key and an alt key, and every column matters equally—there’s no need to prioritise one over another.
Scope
• Review the existing Sales and Fact tables in my PBIX file.
• Design and build a basic bridge table that resolves the many-to-one relationship.
• Configure relationships in the model so lookups, measures, and slicers behave as expected.
• Provide a brief note or screenshot showing the final relationship view and any DAX or Power Query steps used.
This is a small, focused task: get the bridge table in place, confirm that visuals aggregate correctly, and return the updated PBIX.
Scope
• Review the existing Sales and Fact tables in my PBIX file.
• Design and build a basic bridge table that resolves the many-to-one relationship.
• Configure relationships in the model so lookups, measures, and slicers behave as expected.
• Provide a brief note or screenshot showing the final relationship view and any DAX or Power Query steps used.
This is a small, focused task: get the bridge table in place, confirm that visuals aggregate correctly, and return the updated PBIX.