Hi, another way of doing this is to create a duplicate of one table and remove all the duplicates i.e repetative values from that table, and then connect both the tables to the new bridge table created.
I have created a bridge table between two fact table using primary key as you have shown in this video. But when i pull data from all three table then its show error"cant find the relationship". In a table visual i have pulled Employees code from Bridge table and Name & Salary from two fact table. Not working.. please help me out in this problem Thank you
Informative well explained
Glad you liked it
Thank you for your support ...mr.vinayak ji...
Welcome
Very important content.thank you so much
Glad you think so!
Awesome Vinayak bhai . It's very important !!
Thanks so much
Hi, another way of doing this is to create a duplicate of one table and remove all the duplicates i.e repetative values from that table, and then connect both the tables to the new bridge table created.
Yes correct we can do....Also remove other columns too
write a dax suppose you have sales wrt month and we have a slicer for month as we select for feb we should get data for both jan and feb
Okay...Will write in upcoming article.
I have created a bridge table between two fact table using primary key as you have shown in this video.
But when i pull data from all three table then its show error"cant find the relationship".
In a table visual i have pulled Employees code from Bridge table and Name & Salary from two fact table.
Not working.. please help me out in this problem
Thank you
After creating bridge tables, plz connect relationships properly and refresh model once.