Even if UA-cam would have asked me to pay inorder to watch your videos, i would have paid with Honour! Everyone of us could see the efforts you bring in everytime! We appreciate you 🎉 ... We do know that you are already working in some organisation but still you have yhis heart of making the unemployeds like me get into the corporate again. Thank you ❤
I thought you are creating bridge table and connect both tables using cross filtering. You have merged another table columns and didn't shown, How to connect both tables on which key If you try to connect both tables even after merging by adding index column, It will result in many - to - many relationship. Kindly clarify
we have merged it with index key which we have provided but how will it make sure the each record of one table has same values(actual values) since we have provided index in same order?
Its good method, but in real world how do we know shashank has abc address of his ID is 1 When the both table have different dimensions we can cant arrive at any conclusion. We should go to database and find something common or else we can't justify
This solution won't work all the time. How can we make relation ship between this 2 Tables??? How can we confirm whether that 1st customer belongs to 1st address ???
i have just passed the pl300 exam and according to me only one or two weeks of preparation and practice is required if u have better study materials and proper dumps
@@learnwidgiggs this is a sample example that you have taken and now for example i have table student and table student marks but without any relationship in between both the table so how could we get the information student A get this much marks as we don’t have any relation in between those tables
@@fitnesswithbhavi powerbi desktop provides default relationship if you want to create relationship in powerbi desktop click on manage relationship then create on n your own if i am wrong please correct it
Even if UA-cam would have asked me to pay inorder to watch your videos, i would have paid with Honour!
Everyone of us could see the efforts you bring in everytime! We appreciate you 🎉 ... We do know that you are already working in some organisation but still you have yhis heart of making the unemployeds like me get into the corporate again. Thank you ❤
Thank you 🙏
Means a lot ❤️
Watched entire playlist.... Too worth❤❤
Thank you 🙏
Hiii....could u plz make a video on DAX formulas, how to prepare those all 256 syntaxes easily
Very well explained but if i have been ask to create a relationship between these two tables then how would do that ?
It will be 1:1 relationship..with index column
I thought you are creating bridge table and connect both tables using cross filtering.
You have merged another table columns and didn't shown, How to connect both tables on which key
If you try to connect both tables even after merging by adding index column, It will result in many - to - many relationship.
Kindly clarify
Please 🙏 make one video on time intelligence functions (ALL) with differences & scenarios
I have already uploaded a video on this..plz check out the channel
we have merged it with index key which we have provided but how will it make sure the each record of one table has same values(actual values) since we have provided index in same order?
It has to be there otherwise there is no sense of combining the tables.
for example how we are sure shanshank belongs to lucknow why not nagpur?
The data has to be there in that order to combine it properly
@@learnwidgiggs Thank you so much for your explanation 🙌
What if ? it is not in proper order @@learnwidgiggs
but it is create 1 to 1 relationship, what if we want to create 1 to may relationship ?
Great Work. How to proceed if we have duplicate records in those tables. Please
Duplicate records have to be removed.
i think its a many to many relationship on that scenarios we can create bridge table if i am wrong please correct it
Please upload more Important questions videos asked on power BI interview this video is really very helpful for us.
Sure.
What if n.os of rows are not matching with other table? Are we still have to same procedure or its not possible or its a error on the data?
Its the error on the data
Nice ...when you started the video my explanation was same
Great 🤝
Informative and helpful video
Lets say the addresses are not aligned with the customer table? like 1 != 1 how to address that senario?
Hi Shashank, what if the tables are at different level of granularity, it is similar to a false join , we might lose some data right ?
Rightly said
I thought its working as clustered index, learned new term which is surrogate key, thanks bro
Welcome
Its good method, but in real world how do we know shashank has abc address of his ID is 1
When the both table have different dimensions we can cant arrive at any conclusion.
We should go to database and find something common or else we can't justify
This solution won't work all the time.
How can we make relation ship between this 2 Tables???
How can we confirm whether that 1st customer belongs to 1st address ???
Hi Shashank, practically combined table will not make any sense.
How to combine 3 or more tables without common columns.
These are incomplete tables, this doesn’t make any sense to just add an index column, untimely we will get wrong address matching wrt customers
How anyone be sure the row 1 record from both table is for the same customer???
How to get source files to practice from my end.
What will be the experience level of this question sir?
Thank you for a such informative video
Glad to hear this 🙂
We can use append right
No
👏
What will be the approach if there is any duplicate records
Duplicate needs to be removed
very nice and useful video.
Glad to hear this 🙂
Thank You for sharing sir
Welcome
Thank you
Hi...what if we have the duplicate records in both the table???
it means in a table1,table2 if coloumn consists of repeated data that type of data is called duplicate records in both table
Thank you sir
Nice one Bhai 😊
Thank you 🙏
Bro... Cybersecurity wala koi banda lao
We can go with append also right?
No
Sir please reply can a fresher pass pl300 exam? How many months of preperation will be needed for a fresher? Please reply🙏🏻
i have just passed the pl300 exam and according to me only one or two weeks of preparation and practice is required if u have better study materials and proper dumps
2 weeks of proper study.. considering you already have good knowledge in Power BI
how you are so sure that shashank belongs to Lucknow why not nagpur?
The data has to be there in that order to combine it properly
@@learnwidgiggs this is a sample example that you have taken and now for example i have table student and table student marks but without any relationship in between both the table so how could we get the information student A get this much marks as we don’t have any relation in between those tables
@@fitnesswithbhavi powerbi desktop provides default relationship if you want to create relationship in powerbi desktop click on manage relationship then create on n your own if i am wrong please correct it
thank you sir
Welcome 🙂