In this tutorial, I’m going to show you a quite interesting technique on how you can cumulatively compare a best months results to the current month by using DAX very effectively. I personally ran into a scenario wherein I needed to workout how many emails we receive in a day and compare that to a monthly basis. But for this video, I want demonstrate on how you can compare a current month to the best month prior, so you can continuously track what the best month is.
Sam
***** Video Details *****
00:00 Introduction
01:20 Functionality
03:40 MAXX
05:35 Using variables
06:17 Daily sales of best month
07:22 Cumulative sales of best month
08:00 Virtual table using SUMX
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial