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.
@EnterpriseDNA2 жыл бұрын
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!
@samuelvecchio6758 Жыл бұрын
What if i have ti calculate this average for the previous year?
@rishichaitali9 ай бұрын
This is outstanding. I was wrapping my head around this for a long time, and you made it so easy to understand.
@Thoth0Amon Жыл бұрын
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)??
@EnterpriseDNA Жыл бұрын
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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@Thoth0Amon Жыл бұрын
@@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.
@GoofyGooble2 жыл бұрын
This really makes sense, thanks, please upload more contents related to Quick Measures.
@chioke123us1 Жыл бұрын
Thank you ❤
@welcometomathy2 жыл бұрын
What if I want to avg by monty the value of a measure lets
@EnterpriseDNA2 жыл бұрын
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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@tomaszs41882 жыл бұрын
In terms of performance how does it compare to calculate?
@EnterpriseDNA2 жыл бұрын
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 KZbin 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/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ app.enterprisedna.co/app/player-course/24 app.enterprisedna.co/app/player-course/23
@jussiviinamaki649811 ай бұрын
Thank You, So much!!
@Alma-im4qk Жыл бұрын
You talk funny and deep!
@brunohenriquedecastroevald20742 жыл бұрын
Thanks! Helped me a lot!
@hamishmaxa65092 жыл бұрын
This was really good.
@EnterpriseDNA2 жыл бұрын
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!
@djl87102 жыл бұрын
Make a video where you take raw transactional data and do averages for Year/Quarters/Months/Days/Hours so we can reference it.
@EnterpriseDNA2 жыл бұрын
Hi Djl, appreciate the suggestion. We'll include this in our list of possible topics for our future videos. Cheers!