Even if TH-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 ❤
@shashank sir please answer this query There is a table which has 2 columns country,index India,1 Australia,2 Usa,4 India ,5 Canada,6 India,8 When u use filter for country column for India it will show index as 1,5,8 Instead of that it should show 1,2,3 Which dax need to use Please answer
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 TH-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 🙏
@shashank sir please answer this query
There is a table which has 2 columns country,index
India,1
Australia,2
Usa,4
India ,5
Canada,6
India,8
When u use filter for country column for India it will show index as 1,5,8
Instead of that it should show 1,2,3
Which dax need to use
Please answer
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
Informative and helpful video
Nice ...when you started the video my explanation was same
Great 🤝
Please upload more Important questions videos asked on power BI interview this video is really very helpful for us.
Sure.
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
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
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
but it is create 1 to 1 relationship, what if we want to create 1 to may relationship ?
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
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.
I thought its working as clustered index, learned new term which is surrogate key, thanks bro
Welcome
Lets say the addresses are not aligned with the customer table? like 1 != 1 how to address that senario?
How to combine 3 or more tables without common columns.
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
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
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
How anyone be sure the row 1 record from both table is for the same customer???
Thank you for a such informative video
Glad to hear this 🙂
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 ???
How to get source files to practice from my end.
Thank you
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
What will be the experience level of this question sir?
Thank You for sharing sir
Welcome
very nice and useful 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
Hi Shashank, practically combined table will not make any sense.
👏
Nice one Bhai 😊
Thank you 🙏
thank you sir
Welcome 🙂
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
We can go with append also right?
No
Bro... Cybersecurity wala koi banda lao
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