Hi drilldown.ie, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Irfan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Great job on this. Most people learning Power BI have some background working with formulas in Excel, so demonstrating the CALCULATE() function in DAX and drawing a comparison to how one would achieve similar results in Excel is a stroke of genius. Bravo!
Hi James Bartlett, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Liz Leadbetter, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi darryl morgan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Faisal a g, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi P2dj patil, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Shabnam Khan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Hi Vijay Kumar, thanks for posting your comment here in the video. This topic has been discussed several times in Enterprise DNA Forum. You might get the answers you are looking for. If you want to check it out here is the link: forum.enterprisedna.co/search?q=related%20and%20related%20table%20or%20treat%20as%20function
I want to calculate max sum of sale qty of 5 adjacent weeks. Eg. Sum of Weekly qty = week1+2+3+4+5 (total 145) Sum of Weekly qty = week2+3+4+5+6 (total 115) Sum of Weekly qty = week3+4+5+6+7 (total 150) Sum of Weekly qty = week4+5+6+7+8 (total 130) Sum of Weekly qty = week5+6+7+8+9 (total 110) End of the calculation will be last week of FY FY start from April and end it on March Week starts on Monday but 1st Sunday of the April will be in week1. So 1st week could have 1 or 7 days sometimes. From above calculation answer should be max sum of weeks is 150 If user selects a period then the results returned for the selected period.
Hello Amir Tamboli, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model, working of the PBIX file for the reference as well as the results that you're trying to achieve here. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Happy Learning!!! forum.enterprisedna.co/
Hi AZIZ Quazi, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/
@@EnterpriseDNA Thanks for the guidance. But still needs clarification. I am already a member and have access to a few courses like Ultimate Beginners Guide to PBI, DAX, Data Transformation, and Modelling. The resource files are not exactly the same for each of the courses. How do I find the right datasets among them? Thanks in advance.
Hi Catalina Tobon Fernandez, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Time 7:52. 'Sales Product A' measure. What is the purpose of using 'FactTable' as a second argument of Calculate function? Why not just remove this condition?
The second argument of Calculate as you can see is a Filter argument and to filter (as can be seen in excel where we filtered the table/column and only selected Product "A") we have to go to The Fact Table & then specify the column condition i.e. FactTable[Products] = "A". This way we can see the sales related to only product "A".
@@mudassirsyedrashidali9787 I don't think you need to specify the table as an argument. You can just filter the product column for A and it'll replace the existing filter context with the one for product A.
@@feo786 you can exclude the Filter function in this example and get the same result. I didn't do that in this example to keep it simple avoiding Filter function won't work in every scenario.
Hi very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Hi ashish mohan, thanks for posting your comment in the video. All datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks! portal.enterprisedna.co/
![How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update]](http://i.ytimg.com/vi/5khU6jz2MwM/mqdefault.jpg)
![How To Calculate Days Since Last Purchase Using DAX In Power BI [2022 Update]](/img/tr.png)
Helpful, clear and set out in tables that you can refer back to later as quick reminders.
Hi Paul, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Thank you. I always find explanations easier to understand when they reference back to excel formulae, just like you did here. Great stuff!
Hi drilldown.ie, great that you found value in this video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Good explanation..excel version even made it much better..thank you team
Hi Irfan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Great job on this. Most people learning Power BI have some background working with formulas in Excel, so demonstrating the CALCULATE() function in DAX and drawing a comparison to how one would achieve similar results in Excel is a stroke of genius. Bravo!
Hi James Bartlett, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
I especially like the way you compared this to Excel. Very easy to understand.
Hi Liz Leadbetter, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Nicely Explained Easy To Understand and Follow...Thank You Mudassir
Hi darryl morgan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Excellent Video and explanation Mudassir!!
Hi Antriksh Sharma, thank you for always supporting our videos.
Short & Clear explanation.
Thanks for sharing...
Hi Faisal a g, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Very nice... We need all videos like this
Hi P2dj patil, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Great job explaining the calculate function! Thank you!;
Hi Shabnam Khan, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Crystal clear, can you please explain related and related table or treat as function
Hi Vijay Kumar, thanks for posting your comment here in the video. This topic has been discussed several times in Enterprise DNA Forum. You might get the answers you are looking for.
If you want to check it out here is the link: forum.enterprisedna.co/search?q=related%20and%20related%20table%20or%20treat%20as%20function
Sure we will..The trick is just to come up with a way to explain it in simple terms..Soon will be out with a video.Thanks for the ideas.
I want to calculate max sum of sale qty of 5 adjacent weeks.
Eg.
Sum of Weekly qty = week1+2+3+4+5 (total 145)
Sum of Weekly qty = week2+3+4+5+6 (total 115)
Sum of Weekly qty = week3+4+5+6+7 (total 150)
Sum of Weekly qty = week4+5+6+7+8 (total 130)
Sum of Weekly qty = week5+6+7+8+9 (total 110)
End of the calculation will be last week of FY
FY start from April and end it on March
Week starts on Monday but 1st Sunday of the April will be in week1.
So 1st week could have 1 or 7 days sometimes.
From above calculation answer should be max sum of weeks is 150
If user selects a period then the results returned for the selected period.
Hello Amir Tamboli,
thank you for posting your query onto our channel.
Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model, working of the PBIX file for the reference as well as the results that you're trying to achieve here.
And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference.
Hoping you find this useful.
Happy Learning!!!
forum.enterprisedna.co/
Hi, can we have the "Sample Data Used" for this video? Thanks.
Hi AZIZ Quazi, thanks for posting your comment in the video. All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/
@@EnterpriseDNA Thanks for the guidance. But still needs clarification. I am already a member and have access to a few courses like Ultimate Beginners Guide to PBI, DAX, Data Transformation, and Modelling. The resource files are not exactly the same for each of the courses. How do I find the right datasets among them? Thanks in advance.
Great content, Thank you
Hi Catalina Tobon Fernandez, glad you appreciated the video. You can subscribe to our channel to see all our upcoming Power BI video tutorials.
Here’s the link: th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
Time 7:52. 'Sales Product A' measure. What is the purpose of using 'FactTable' as a second argument of Calculate function? Why not just remove this condition?
The second argument of Calculate as you can see is a Filter argument and to filter (as can be seen in excel where we filtered the table/column and only selected Product "A") we have to go to The Fact Table & then specify the column condition i.e. FactTable[Products] = "A". This way we can see the sales related to only product "A".
@@mudassirsyedrashidali9787 I don't think you need to specify the table as an argument. You can just filter the product column for A and it'll replace the existing filter context with the one for product A.
@@feo786 yes its the same thing. Either way you are accessing the same table. Accessing the column is the optimized way of getting the same result.
@@mudassirsyedrashidali9787 I'm not sure I understand what you mean.
@@feo786 you can exclude the Filter function in this example and get the same result. I didn't do that in this example to keep it simple avoiding Filter function won't work in every scenario.
Hi
very useful video and very practical need everyone for every project ......very big thanks to share with us.
If it can possible can you plzz provide us excel data file which you used.
Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Hi ashish mohan, thanks for posting your comment in the video. All datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Find link below. Thanks!
portal.enterprisedna.co/