Man I would love to see more content like this. Like a lot more. Its hilarious to me how Greg is like here is this easier to understand way to do something without calculate and I get what he is doing right away. I am curious though if you can always avoid calculate.
Hi Richard, 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!
Ironic I was just digging into this today building a query; but how can I run this over two categories that average over the value column over a specific date range (DATESINPERIOD; basically getting the last three months)??
Hello Thoth0Amon, It's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. 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! If you haven't yet, you can subscribe to our TH-cam channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/
@@EnterpriseDNA Thanks, I'll check out the Community Forum. I did find a solution in my particular case; the trick was using ALLEXCEPT nested in a calculated column inside SUMMARIZECOLUMNS. Sort of weird compared to a similar case using SQL where you'd pivot or something, but it works for setting up multiple groupings under one table summary. The Averaging part was done by using DATESINPERIOD and dividing out the columns by that period.
Hello WelcomeToMathy, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, the query which you've raised is not clear to us here. Can you please re-post the query by elaborating the scenario that you're trying to achieve? Or else provide the proper PBIX file by posting the query along with the description onto our Community Forum 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! You can subscribe to our TH-cam channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/
Hello Tomas, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. To learn about the performance optimization, we've created a dedicated course available onto our Enterprise DNA education portal. Below is the link of the course provided for the reference. For furthermore queries, you can also reach out to us onto our Community Forum 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 as well. Hoping you find this useful! You can subscribe to our TH-cam channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/ app.enterprisedna.co/app/player-course/24 app.enterprisedna.co/app/player-course/23
Hi Hamish, 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!
Check out our FREE courses: bit.ly/3N00AJw
Man I would love to see more content like this. Like a lot more. Its hilarious to me how Greg is like here is this easier to understand way to do something without calculate and I get what he is doing right away. I am curious though if you can always avoid calculate.
Hi Richard, 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!
What if i have ti calculate this average for the previous year?
Thank you ❤
This is outstanding. I was wrapping my head around this for a long time, and you made it so easy to understand.
This really makes sense, thanks, please upload more contents related to Quick Measures.
Ironic I was just digging into this today building a query; but how can I run this over two categories that average over the value column over a specific date range (DATESINPERIOD; basically getting the last three months)??
Hello Thoth0Amon,
It's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference.
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! If you haven't yet, you can subscribe to our TH-cam channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
@@EnterpriseDNA Thanks, I'll check out the Community Forum.
I did find a solution in my particular case; the trick was using ALLEXCEPT nested in a calculated column inside SUMMARIZECOLUMNS. Sort of weird compared to a similar case using SQL where you'd pivot or something, but it works for setting up multiple groupings under one table summary.
The Averaging part was done by using DATESINPERIOD and dividing out the columns by that period.
Thank You, So much!!
What if I want to avg by monty the value of a measure lets
Hello WelcomeToMathy,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
Well, the query which you've raised is not clear to us here. Can you please re-post the query by elaborating the scenario that you're trying to achieve? Or else provide the proper PBIX file by posting the query along with the description onto our Community Forum 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! You can subscribe to our TH-cam channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
In terms of performance how does it compare to calculate?
Hello Tomas,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it.
To learn about the performance optimization, we've created a dedicated course available onto our Enterprise DNA education portal. Below is the link of the course provided for the reference.
For furthermore queries, you can also reach out to us onto our Community Forum 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 as well.
Hoping you find this useful! You can subscribe to our TH-cam channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
app.enterprisedna.co/app/player-course/24
app.enterprisedna.co/app/player-course/23
You talk funny and deep!
Thanks! Helped me a lot!
This was really good.
Hi Hamish, 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!
Make a video where you take raw transactional data and do averages for Year/Quarters/Months/Days/Hours so we can reference it.
Hi Djl, appreciate the suggestion. We'll include this in our list of possible topics for our future videos. Cheers!
not good. no discussion of performance.