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