Reply
dr_anas
Frequent Visitor
Partially syndicated - Outbound

Building relations

I need your assistance to fix the relationship between the two tables in the screenshot.

I need to establish a relationship with the bonus table, and I have a fact sales table, but it is arriving many to many, and I need it one to many.

 

Kindly be advised that:

1- Since items might be found in multiple departments, department IDs are duplicated.

2- Because it contains various quantities as a bounce in different months, the item is duplicated.bonus relation PBI.png

2 REPLIES 2
Idrissshatila
Super User
Super User

Syndicated - Outbound

hello @dr_anas , 

 

in order to help you, we need to understand the logic about the relation between the fact sales and the bonus table.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicated - Outbound

The logic goes like this: the number of bonuses quantities for each item over the date has to be computed. Each item has a bonus with zero value quantities sold throughout the year.

I wish it is clear now If not, please let me know so that I can clarify more.

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)