In today’s video I we will go through how to build a time intelligence measure in DAX using the PREVIOUSDAY, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR. We will first go through PREVIOUSYEAR DAX function and explain how can those functions can be combined with CALCULATE to create the correct measure.
We move on to PREVIOUSQUARTER DAX functionwhere we go through how to that measure works and create an example.
Next will be PREVIOUSMONTH DAX function where we go through what the “first day in the current context” means.
And finally we go through PREVIOUSDAY DAX example where we go through what happens when we dont have continuous days in our sales table.
Keynotes:
01:48 PREVIOUSYEAR
04:05 PREVIOUSQUARTER
05:24 PREVIOUSMONTH
06:41 PREVIOUSDAY
Link to the power bi file:
Get Northwind Dataset:
Link to DAX Fridays survey:
Looking for a download file? Go to our Download Center:
SUBSCRIBE to learn more about Power and Excel BI!
Our PLAYLISTS:
- Join our DAX Fridays! Series:
- Power BI dashboards for beginners:
- Power BI Tips & Tricks:
- Power Bi and Google Analytics:
ABOUT CURBAL:
Website:
Contact us:
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo
► Google +:
► Facebook:
#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP
0 Comments