Today, I’ll demonstrate how you can easily calculate This Year VS Last Year, or any time comparison in general, with a couple of techniques. This I believe is one of the first skills I think you should work through as you’re learning how to operate DAX effectively in Power BI Desktop.
Sam
**** Video Details ****
00:00 Introduction
00:44 Waterfall technique
01:35 Creating a core measure
02:20 SAMEPERIODLASTYEAR function
03:52 Year on Year with measure branching
04:42 Creating visualization
05:05 Creating a slicer for a specific month
05:50 The AnalystHub
06:25 Last Year quantity with DATEADD
**** Related Links ****
Creating The Ultimate Date Table In Power BI How To Do This Fast (Updated Code) • Creating The Ultimate Date Table In P...
Ultimate Beginners Guide to Power BI 2020 Creating A Date Table • Ultimate Beginners Guide to Power BI ...
Using The DATEADD Function For Effective Time Related Insights • Using The DATEADD Function For Effect...
**** Learning Power BI? ****
FREE COURSE Ultimate Beginners Guide To Power BI http://portal.enterprisedna.co/p/ulti...
FREE COURSE Ultimate Beginners Guide To DAX http://portal.enterprisedna.co/p/ulti...
FREE Power BI Resources http://enterprisedna.co/powerbireso...
FREE 60 Page DAX Reference Guide Download https://enterprisedna.co/daxformula...
Enterprise DNA Membership https://enterprisedna.co/membership
Enterprise DNA Online http://portal.enterprisedna.co/
Enterprise DNA Events https://enterprisedna.co/enterprised...