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
Anonymous
Not applicable

Target vs Actual

Hi All, 

 

I have 2 tables - 1 for Actual Sales from SAP BW, OTher is Targets in an Excel. 

We have targets by Region Level by SKU. 

I made a relationship btw 2 tables with a calc.column Region&SKU. 

My problem is: If there is no target for a specific region and SKU, I cannot see the actual and grand total does not become true for that region in actual sales. 

Please help me correct that. 

 

Regards.

1 ACCEPTED SOLUTION

 

 

Never join two data tables together directly. Instead join to a common lookup table, where the lookup table has a superset of every value in the columns in the joins. 

 

https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

1 REPLY 1

 

 

Never join two data tables together directly. Instead join to a common lookup table, where the lookup table has a superset of every value in the columns in the joins. 

 

https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

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.