I have a question( as I am a beginner i apologize for my naive question). Why should we make relationships between order date and calendar AND ship date and Calendar. But for example for sales, profit, ... we don't need to make such relationships and we can get the sales, the profit for each year separately without making inactive relations and writing dax to make it active and etc
Hi, to get the correct count for shipments and orders based on the date selection from the slicer, we need to create relationships between the calendar date, order date, and ship date. Please watch the video carefully, as I explain why these relationships are necessary.
I am watching this part as well. Thank you very much
You are welcome.
If you like the video, please like, share, comment, and subscribe to the channel for more videos. 🙏
Really very helpful. For starter and any profession who wants to switch to Power BI.
@@mohammedmuzzammil1184 Thanks 😊
Almost all functions are covered which are used on a daily basis to make a dashboard..
This is very helpful to a beginner.
Thanks Ram
I have a question( as I am a beginner i apologize for my naive question). Why should we make relationships between order date and calendar AND ship date and Calendar. But for example for sales, profit, ... we don't need to make such relationships and we can get the sales, the profit for each year separately without making inactive relations and writing dax to make it active and etc
Hi, to get the correct count for shipments and orders based on the date selection from the slicer, we need to create relationships between the calendar date, order date, and ship date. Please watch the video carefully, as I explain why these relationships are necessary.