This Year VS Last Year Time Comparisons & Differences In Power BI

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/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...