Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
voiciK
Frequent Visitor

Relationship table - Actual to Budget

Hi All,

 

I am new to Power BI and do not fully understand the relationship among tables.

 

I cannot workout how to set up the relationship between the actual and budget tables.

 

So my Actual table is:

voiciK_0-1634182513619.png

And my Budget table is:

voiciK_1-1634182560049.png

I want to create a matrix report to compare actual & budget data, and put a filter to Store & Date range. Something like this:

voiciK_2-1634182749830.png

I tried creating a Date table & a Store table then link the actual & buget to these 2 tables but I think I did something wrong. Here are my links:

voiciK_3-1634183026596.png

I linked the Date from Date_Table to the Date in 2 main datasets.

Then Store from Store list to Store in 2 main datasets.

Finally link the Product of 2 main datasets together.

These are the Fields I used:

voiciK_4-1634183364599.png

 

Thank you for your help!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@voiciK , You should not join Fact. You should have join between actual and budget . If need create a common product dimension.

 

remove that join and correct rest of the joins

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@voiciK , You should not join Fact. You should have join between actual and budget . If need create a common product dimension.

 

remove that join and correct rest of the joins

Thanks I fixed it! 👍

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.