2 Rules to Build a One to Many Relationship in Power BI

Join this channel to get access to perks:
/ @goodlychandeep
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[@tiagocarvalhal4502]

Additionally, take in consideration that power query is case sensitive and power BI it isn't. You may haven't duplicates on the power query and have duplicates on the power bi side. Solution - for example do the uppercase on both columns you are connecting 😊👌

[@nunofaia]

Create a Table that have unique value of product id?

[@JJ_TheGreat]

How does Power BI handle many-to-many relationships?

[@ArmandoReportes]

It gives you the rows that match the field in the tables you select them from. If you include fields from both tables, you get an inner join.

[@SeyPras.]

I have a date dimension table connected to my fact table. I don’t have blank values in dim date.. but somehow it won’t filter my dates against my dax measure e.g. count of order from fact table. What might be the issue here?

[@praveensahni5547]

Can null values in fact table * also cause error ? Or we should only take care for dim table