Forum Discussion
Ehab-H
5 years agoFrequent Visitor
Lookup data between three tables
Hi folks After multiple attempts - I finally decided to post here for some help. We have orders that can either be generated against the customer or the contact. In our report, we have three rel...
Jihwan_Kim
5 years agoSuper User
Hi, Ehab-H
Please correct me if I wrongly understood your question.
I am not sure how your fact table looks like, but if I may suggest, I like to suggest the below structure. The sample pbix file's link is down below.
https://www.dropbox.com/s/e67ti6e8rf8t95i/ehab.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/