This video you learn 5 ways in which you can calculate the last 12 months in DAX. The goal is to master different ways to reach the same result.
Which method is your favorite?
WRITTEN BLOGPOST:
https://gorilla.bi'>https://gorilla.bi/dax/5waystocalc...
Master Functions and Syntax in M
https://powerquery.how
0:00 Introduction
0:45 The scenario
1:05 Version 1: DATESINPERIOD
3:14 Version 2: DATESBETWEEN
5:25 Version 3: Using an Index Column
8:12 Version 4: MAXDATE and EDATE
9:44 Version 5: LASTDATE and SAMEPERIODLASTYEAR
ABOUT BI Gorilla:
BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills.
SUPPORT MY CHANNEL
Any videos are made free of charge. You can support my channel by giving a donation through: https://paypal.me/rickmaurinus.
Website: https://gorilla.bi'>https://gorilla.bi
SUBSCRIBE TO MY CHANNEL
https://youtube.com/bigorilla?sub_con...
LET'S CONNECT:
Blog: https://gorilla.bi'>https://gorilla.bi
Facebook: / bigorilla
Twitter: / rickmaurinus
LinkedIn: / rickmaurinus
Thank you for your support!
#PowerQuery #Last12Months #BIGorilla