Check out the Related function in DAX video ▶ - ruclips.net/video/6BdnQS-hZvw/видео.htmlsi=owDSoBp8N42e28nX Download the file ⬇ - goodly.co.in/mastering-snowflake-schema-calculations-power-bi
Hi Chandeep, at the 4:00 timestamp, you filtered to Jul-11 when you meant to select Jun. Not a huge deal as I can see Jul-11 also had an error in SUM from the original DAX formula. Great explanation & solution. Thanks!
Great comunication here - This is fundermental chaps - you need to ensure you use this process - even if there are multipule dates needing reporting the same fact table that need reporting
Thank you for your videos. 2 Questions: 1. May I ask why you didn't create a transaction ID table in Power Query, then used it along with your your date table to separately connect to the Sales & Refund tables, using the new transaction ID field in the new table in your visuals? 2. Is there a benefit to creating your calendar table in DAX as opposed to Power Query?
Even if you do point 1, it won't help take the filters from the products or sales to refunds (in a one to many relationship format). Plus it makes the model unnecessarily complicated. I mostly create date table in power query but I used DAX for this one :)
As per my understanding Snowflake schema contains only Normalized Dimension table but I got confused to know that even it may contain normalized fact table also. Could you share any document on this?
📝 Summary of Key Points: 📌 Snowflake schemas are a type of relationship called a fact of a fact relationship, which presents challenges when creating calculations in Power BI. 🧐 The speaker's goal is to calculate the total number of units refunded, but they encounter a discrepancy in the results when filtering by month due to transactions being sold in one month but refunded in another. 🚀 The speaker suggests two approaches to solve this problem: deleting the relationship between the refunds table and the sales table and creating a new relationship directly between the refund date and the calendar date, or creating an inactive relationship between the refund date and the calendar date and modifying the calculation using the CALCULATE function and the secondary relationship. 💡 Additional Insights and Observations: 💬 "The relationships between the tables propagate filter context, which can lead to discrepancies in calculations when dealing with snowflake schemas." 📊 No specific data or statistics were mentioned in the video. 🌐 The speaker mentions their DAX, M language, and Power Query courses for those interested in learning more about Power BI. 📣 Concluding Remarks: This video provides insights into dealing with snowflake schemas and fact of a fact relationships in Power BI. It highlights the challenges of calculating values between tables with different granularities and demonstrates how to validate and fix the calculations. The speaker also mentions their courses for those interested in further learning. Generated using Talkbud (Browser Extension)
Hi, @8:55 the scope is limited to this measure only and not 'whenever we use calendar date in filter context' of any visual. Just a suggestion to be more specific.
Sir...pls help Sir, while click on content... Detail displayed but file name column remove.... How to fix the problem... I am extract csv format file through power query
Hi, I have a very difficult question and I searched through the Google and chatgpt and everywhere but couldn't find a solution for that. I have an idea to combine two different maps one is going to be in shape file and the other one is going to be point map. So my idea is to make the background of the point map transparent and only leave the points by latitude and longitude so that I can make a group of points by latitude and longitud with the shaple file map and putting the points by latitude and longitud over the shape file. Finally, make them on group which will appear like that I have both shaple file plus points by latitude and longitud together. But until now I couldn't find a solution how to remove or make the point map background transparent or without having any colour except the points by latitude and longitud. Please help me in this regard. Thanks in advance.
The underlying data model is BAD. You don’t join ‘facts to facts’. The refund fact table should look just like the sales table. If you have one record per item sold in the Sales fact, you should have one item per refund in the Refund fact table. That is, they should be at the same grain. Some might argue that both your sales and refunds should (and can) be in the same table. Your refund table makes no sense. Jumping through all of this hoops in Power BI creates technical debt. Difficult to understand and maintain. You’re doing your viewers a disservice by demonstrating this. Fix it in the data model.
I suppose in the real word the Sales table would have one record per item which would allow the 2 facts to be merged. You don't always choose the data you work with though, you would probably design the same data model if you had to use the tables as they are presented in the video. 'You don't join facts to facts' - I see this statement quite often but I don't fully understand it, could you explain how would you model a many-to-many Order-Invoice relationship without joining the facts together via a bridge table?
Sry, this is total bullshit theory based on theories from MS and other sites or books, sometimes u have to join them. Theory and reality is way different, based on years of experience. Data and business reality doesn’t match theories. Connecting with same dimmensions, denormalizing etc…yeah and at the end u have to write ton la of code to kill cartessians, crossjoins and all this terrible stuff.
Check out the Related function in DAX video ▶ - ruclips.net/video/6BdnQS-hZvw/видео.htmlsi=owDSoBp8N42e28nX
Download the file ⬇ - goodly.co.in/mastering-snowflake-schema-calculations-power-bi
Hi Chandeep, at the 4:00 timestamp, you filtered to Jul-11 when you meant to select Jun. Not a huge deal as I can see Jul-11 also had an error in SUM from the original DAX formula.
Great explanation & solution. Thanks!
Excellent work
😊
Was wondering the same…!
Was wondering about the same, but I think the explanation is to find at the 6:45 timestamp. It doesn't matter wich month is filtered at 4:00!?
@@juja2819 Agreed
I was too engrossed to mis-select the filter but luckily it worked 🤣🤣
My man… U have no idea how often I am going to use this. Not just to really USE it, but now a lot of other stuff also suddenly makes sense… ❤
Looking for an excuse to use this idea in the future!
Thanks Chandeep.
Great comunication here - This is fundermental chaps - you need to ensure you use this process - even if there are multipule dates needing reporting the same fact table that need reporting
Brother, I appreciate the straightforward explanation. You're truly invaluable.
Great video very clear and smart to create secondary relationships that are not active and then call them specifically on specific DAX queries.
Well explained, straightforward and to the point. Thanks!
Very informative! Keep up the good content!
while checking the refund there was a little confusion July instead of June?
Nice vid, question: wouldnt change it to both directions filtering in the relationship also work in this case?
Excellent, thanks Chandeep!
Thank you for your videos. 2 Questions:
1. May I ask why you didn't create a transaction ID table in Power Query, then used it along with your your date table to separately connect to the Sales & Refund tables, using the new transaction ID field in the new table in your visuals?
2. Is there a benefit to creating your calendar table in DAX as opposed to Power Query?
Even if you do point 1, it won't help take the filters from the products or sales to refunds (in a one to many relationship format). Plus it makes the model unnecessarily complicated.
I mostly create date table in power query but I used DAX for this one :)
Finished watching
Excellent video! Thanks!
Love the explanation!
As per my understanding Snowflake schema contains only Normalized Dimension table but I got confused to know that even it may contain normalized fact table also. Could you share any document on this?
Great use case 👌 More tutorials like this please
3:53 You choose July instead of June in the refund table.
a big Thamks for the sharing of tutorial
Superb
You are awesome thank you
Nice one Chandeep.
Excellent..🎉
Nice video and explanation. is there any performance degradation using this strategy?
Not that I have faced
Nicely explained. love it
Will treat as work
Awesome, thank you! :)
Awesome 😆
📝 Summary of Key Points:
📌 Snowflake schemas are a type of relationship called a fact of a fact relationship, which presents challenges when creating calculations in Power BI.
🧐 The speaker's goal is to calculate the total number of units refunded, but they encounter a discrepancy in the results when filtering by month due to transactions being sold in one month but refunded in another.
🚀 The speaker suggests two approaches to solve this problem: deleting the relationship between the refunds table and the sales table and creating a new relationship directly between the refund date and the calendar date, or creating an inactive relationship between the refund date and the calendar date and modifying the calculation using the CALCULATE function and the secondary relationship.
💡 Additional Insights and Observations:
💬 "The relationships between the tables propagate filter context, which can lead to discrepancies in calculations when dealing with snowflake schemas."
📊 No specific data or statistics were mentioned in the video.
🌐 The speaker mentions their DAX, M language, and Power Query courses for those interested in learning more about Power BI.
📣 Concluding Remarks:
This video provides insights into dealing with snowflake schemas and fact of a fact relationships in Power BI. It highlights the challenges of calculating values between tables with different granularities and demonstrates how to validate and fix the calculations. The speaker also mentions their courses for those interested in further learning.
Generated using Talkbud (Browser Extension)
Super
Thank you 🙏
Hi, @8:55 the scope is limited to this measure only and not 'whenever we use calendar date in filter context' of any visual. Just a suggestion to be more specific.
or June Sale refund in July?
Sir...pls help
Sir, while click on content... Detail displayed but file name column remove.... How to fix the problem... I am extract csv format file through power query
Hi, I have a very difficult question and I searched through the Google and chatgpt and everywhere but couldn't find a solution for that. I have an idea to combine two different maps one is going to be in shape file and the other one is going to be point map. So my idea is to make the background of the point map transparent and only leave the points by latitude and longitude so that I can make a group of points by latitude and longitud with the shaple file map and putting the points by latitude and longitud over the shape file. Finally, make them on group which will appear like that I have both shaple file plus points by latitude and longitud together. But until now I couldn't find a solution how to remove or make the point map background transparent or without having any colour except the points by latitude and longitud. Please help me in this regard. Thanks in advance.
wow.....
❤❤❤
3:58, you selected july instead of june
This problem happens also when you merge 2 tables in power query as well
Your courses are too expensive please think about students or working professional who are from India also 🙏
The underlying data model is BAD. You don’t join ‘facts to facts’. The refund fact table should look just like the sales table. If you have one record per item sold in the Sales fact, you should have one item per refund in the Refund fact table. That is, they should be at the same grain. Some might argue that both your sales and refunds should (and can) be in the same table. Your refund table makes no sense. Jumping through all of this hoops in Power BI creates technical debt. Difficult to understand and maintain. You’re doing your viewers a disservice by demonstrating this. Fix it in the data model.
I suppose in the real word the Sales table would have one record per item which would allow the 2 facts to be merged. You don't always choose the data you work with though, you would probably design the same data model if you had to use the tables as they are presented in the video. 'You don't join facts to facts' - I see this statement quite often but I don't fully understand it, could you explain how would you model a many-to-many Order-Invoice relationship without joining the facts together via a bridge table?
Sry, this is total bullshit theory based on theories from MS and other sites or books, sometimes u have to join them. Theory and reality is way different, based on years of experience. Data and business reality doesn’t match theories. Connecting with same dimmensions, denormalizing etc…yeah and at the end u have to write ton la of code to kill cartessians, crossjoins and all this terrible stuff.
you said June and you select July ruclips.net/video/W915aEqEkz4/видео.html LOL!