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?
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!
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.
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.
Help! I need an average duration of only open tickets across time (weeks). Open meaning, if created date < calendar start of the week AND closed date > calendar end of the week or blank. I know duration days and average and related but can’t at all put them altogether 😢
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
Hi Daniel, i do a very similar solution here which just calculates the difference between two points, perhaps it can help: ruclips.net/video/o2jSUHU722w/видео.html
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!
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 ?
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
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.
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 ruclips.net/video/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 ruclips.net/video/fOcgIuaJHEs/видео.html Hope these help!
@@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 ruclips.net/video/OUsx-byvTWM/видео.html
@@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.
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!
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 😂
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!
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?
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!
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.
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.
Great video, watched 3 other videos before this one that didn't have as thorough of an explanation. Thank you!
You're welcome, thanks for watching!
clear and concise . and table portion of AVERAGEX made it much clear.
It's a wonderful explanation, especially for DAX lovers. Thank you, Brother !!!!!!!!! Keep Uploading .
Help! I need an average duration of only open tickets across time (weeks). Open meaning, if created date < calendar start of the week AND closed date > calendar end of the week or blank. I know duration days and average and related but can’t at all put them altogether 😢
You explained very well. Thanks Fernan
Glad it was helpful!
this guy is the best powerBI teacher
Appreciate the compliment, thanks!
Makes a lot of sense. Thank you
Thanks for watching!
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)
Hi can you show how to user Averagex for Average per week calculations
Hi Arti, you'll need to use SUMMARIZE to group your days into weekly averages
How can i take average of averages of two different measures?
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
Hi Daniel, i do a very similar solution here which just calculates the difference between two points, perhaps it can help: ruclips.net/video/o2jSUHU722w/видео.html
Hi, if I want to get an overall average by various categories using distinct count for the customer, how do I do this?
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!
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 ?
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
Thank you for your great content!
Glad you enjoy it!
Average and AverageA both igoners the blank values.
Whrs the link of data?
Simple training
Great!
Great, thanks
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.
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
ruclips.net/video/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
ruclips.net/video/fOcgIuaJHEs/видео.html
Hope these help!
@@SolutionsAbroad thank you very much I will check and let you know the results
@@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
ruclips.net/video/OUsx-byvTWM/видео.html
@@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.
@@riazuddin7493 Fantastic, glad I could help!
Good clear vid, but background music is super annoying.
My average A not counting blanks ? Giving same result like average
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!
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 😂
HI, where is the link to this pbi file
Hi RJ, all links are available through my Patreon: www.patreon.com/posts/demo-files-52538104
you are awesome thanks...just you are a little bit fast.
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!