Virtual Relationship in Power BI - Calculate Without Any Relationship Between Tables

How to get data from one table without creating a relationship in Power BI?
Well, it is possible to do so. There is a work around in Power BI where we can actually get data from one table and link with another table without any relationship in between. We do that using what I call a 'Virtual Relationship' in Power BI.

Hey Guys,

Welcome to my channel Power BI with Rosh. In this video, I am going to show you how we can create a virtual relationship between any two tables.
In some cases, when you are creating a Power BI report, you can not establish relationship between two tables but you want to get data from one table to another when reporting.

In such case, we can create a virtual relationship between two tables and that's what I am going to show you in this video.

Hope you will enjoy this tutorial in Power BI.

Thanks,
Rosh

[umabhogereddi]

Thank you so much... you save our day today

[haribahadurrokaya]

Thanks Rosh. Your videos are really helpful. Keep it up.

[dhirajjadhav]

Thank you very much for this, it's very useful Dax function, It helps me a lot