Power BI users often encounter the requirement of calculating averages per day when dealing with time-based data such as sales, web traffic, or social media activity. This calculation helps to provide a more accurate representation of performance trends and fluctuations over time, especially when compared to absolute values. In this tutorial, Sam will show how you can easily calculate averages per day using DAX in Power BI.
*****Video Details*****
00:00 Introduction
0:29 Data model
00:45 Total sales by customer
01:45 Averages sales per day by customer
03:10 Changing the time frame
03:48 Recap of the process
04:55 Applying the same formula against different dimensions
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial