How to use AVERAGE, AVERAGEA and AVERAGEX in Power BI // Beginners Guide to Power BI in 2020

Подписаться 45 тыс.

Просмотров 45 тыс.

50% 1

In this video we go through a step by step guide on how you can use AVERAGE, AVERAGEA and AVERAGEX to make your Power BI Development easier.
I go through some brief explanation on what they are and their minor differences, as well as a few real-life scenarios and situations of when you could use them effectively.
For the most part these functions are pretty simple, but only effective if understood, so the examples go through includes some concepts of what the function actually does behind the scenes, in order to better conceptualise their inner workings.
-
⏲ TIMESTAMPS
Introduction: (0:00)
Average: (0:46)
AverageA: (3:17)
AverageX: (5:55)
Summary: (10:30)
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of RU-vid.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

Опубликовано:

10 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@MrWhoabuddy 3 года назад

what is the advantage of using these functions within PowerBI instead of first doing the math in Excel and then just using PowerBI to display the data?

@SolutionsAbroad 3 года назад

Hey mate, thanks for watching the video! These functions are used on measures which are dynamic in nature. It means that the functions recalculate on-the-fly as the user slices and dices the Power BI report, depending on the context. Great question, I will try to cover this question in video form with an example, keep an eye out for that!

@MrWhoabuddy 3 года назад

Power BI with Fernan thanks Fernan. I usually do most of my calculations in excel and use PowerBi as a clean interface to display the end product. I’m definitely interested in how I can use powerbi more. Great content by the way. Great quality. Looking forward to seeing more.

@zeniawaters4018 2 года назад

Hello, wanted to add a reason for doing this calculations within Power BI would be to automate reporting processes. Rather than pulling the data into Excel, running calculations, then pulling the data into Power BI for visualizations, you can run the calculations and visualizations in Power BI with cutting out that middle step. Should help save time and effort.

@zeniawaters4018 2 года назад

Great video, watched 3 other videos before this one that didn't have as thorough of an explanation. Thank you!

@SolutionsAbroad 2 года назад

You're welcome, thanks for watching!

@kunjal96 2 года назад

It's a wonderful explanation, especially for DAX lovers. Thank you, Brother !!!!!!!!! Keep Uploading .

@narshimagoudpalakurla9651 10 месяцев назад

clear and concise . and table portion of AVERAGEX made it much clear.

@eyitayoeyitayo-lawal2331 3 года назад

Makes a lot of sense. Thank you

@SolutionsAbroad 3 года назад

Thanks for watching!

@RehanShaikh-ip9hh 2 года назад

You explained very well. Thanks Fernan

@SolutionsAbroad 2 года назад

Glad it was helpful!

@tuaantuaan2323 3 года назад

Thank you for your great content!

@SolutionsAbroad 3 года назад

Glad you enjoy it!

@zohrehkarimi4319 2 года назад

Great, thanks

@granand 2 года назад

Thank you mate, a question. I have departments under them Groups and then Categories and then Products. If I calculate AVERAGE(Products) and use Departments, groups, categories which are made unique and creaed dIM tables to link them with fact table. When I use each of them as filter, will I still get the average ?

@SolutionsAbroad 2 года назад

Hi, Yes it will exactly! The whole point of measures is that it's context can be changes, so if you filter by department or other categories as long as your relationships are set up

@willow3601 2 года назад

Hi, if I want to get an overall average by various categories using distinct count for the customer, how do I do this?

@SolutionsAbroad 2 года назад

Hi Willow, you'll need to use SUMMARIZE in order to use the AVERAGE per category. Although a quick and dirty way is to just create a table of categories and drag in the sales average, this will do the job for you really quickly!

@danielansu9155 2 года назад

Hello, I want to calculate different temperature over time, 12/3/2021,12pm-5degrees, 12/3/2021,5pm-2 degree so a difference of 2 degrees, how do I go about this in powerbi

@SolutionsAbroad 2 года назад

Hi Daniel, i do a very similar solution here which just calculates the difference between two points, perhaps it can help: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-o2jSUHU722w.html

@kshamaasrivastava1237 Год назад

How can i take average of averages of two different measures?

@diamondunbreakable3257 3 года назад

this guy is the best powerBI teacher

@SolutionsAbroad 3 года назад

Appreciate the compliment, thanks!

@artimattoo8708 2 года назад

Hi can you show how to user Averagex for Average per week calculations

@SolutionsAbroad 2 года назад

Hi Arti, you'll need to use SUMMARIZE to group your days into weekly averages

@riazuddin7493 3 года назад

Hi I want to prepare the HR dashboard but a little confused as to how to use the slicer so that it shows me cumulative headcount of each year instead of showing the headcount of staff who joined in the same year. Please note that I just have date of joining in my data. Kindly also help me for Resignation on the same pattern also how to calculate turnover percentage using only last working date.

@SolutionsAbroad 3 года назад

Hi Riaz great question! We need to breakdown your questions into separate bits; - To get the Headcount, you need to use their start date and termination date. You need to create a measure which calculates, at a specific date, if an employee start date >= date, or termination date < today, or no termination date - To get the Cumulative Headcount, you need to use the running total quick measure, I cover how to do it easily in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-SFISgDUwuoA.html - To get turnover, you also need the leavers, which you will need a measure for. Here's a video I cover about how to count leavers in a measure. You can use this in combination of the headcount to calculate your turnover ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fOcgIuaJHEs.html Hope these help!

@riazuddin7493 3 года назад

@@SolutionsAbroad thank you very much I will check and let you know the results

@SolutionsAbroad 3 года назад

@@riazuddin7493 you're welcome! If you're still having trouble and want to see how to do it from scratch, i will try to cover it during my livestream this Saturday ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-OUsx-byvTWM.html

@riazuddin7493 3 года назад

@@SolutionsAbroad Hi Fernan thank you for all your help I was able to use the running total quick measure through which i got the desired result of cumulative headcount. Great video indeed! I have also seen your video on turnover but not able to do the turnover percentage calculation on year on year basis leavers divided by average headcount of that year/month/quarter. Can you kindly help me? Also would you reply me on email if I share any file asking for solution? I would greatly appreciate your help. I will also attend your live streaming this Saturday positive. Thanks for all your help.

@SolutionsAbroad 3 года назад

@@riazuddin7493 Fantastic, glad I could help!

@alanruiz4720 5 месяцев назад

anyone can help me with this? I want to get the average, standard deviation, etc, but for only the last 30 data points (not days)

@marymwai4072 2 года назад

Simple training

@SolutionsAbroad 2 года назад

Great!

@rj-pu8yy 2 года назад

HI, where is the link to this pbi file

@SolutionsAbroad 2 года назад

Hi RJ, all links are available through my Patreon: www.patreon.com/posts/demo-files-52538104

@pallavidhatrak8984 4 месяца назад

Whrs the link of data?

@saikumarchebrolu1071 2 года назад

Average and AverageA both igoners the blank values.

@raju_dasari_030 3 года назад

My average A not counting blanks ? Giving same result like average

@SolutionsAbroad 3 года назад

Hi Raju thanks for watching! AverageA should be treating nulls and non-numerics as 0. Check your data types, maybe your data types are non-numeric. Hope that helps!

@raju_dasari_030 3 года назад

My data type is whole number , for average (total / only numeric) for average A (total/numberic +blanks) I'm correct ?...as u mentioned in excel ,where I am doing same , getting same result for both 😂

@foziayimam4159 3 года назад

you are awesome thanks...just you are a little bit fast.

@SolutionsAbroad 3 года назад

Thanks for watching! Yes I do agree with you on this one actually, I'm trying a lot harder to do less scripting and more raw commentary in my recent videos which I hope is a lot slower than this one. Thanks for the feedback!