DAX Patterns: Month-related calculations
These are in-depth video lectures of the
pattern. Month-related calculations
This pattern describes how to compute
month-related calculations such as year-to-date, same period last year, and percentage growth using a month granularity. This pattern does not rely on DAX built-in time intelligence functions.
You can use the Month-related calculations pattern if the analysis over sales is executed at the month level (or above) only. In other words, the formulas stop working if you drill down to the date level. Because the pattern does not use real dates to link to sales, you can also implement fiscal calendars with 13 months and any non-standard time-related calculation – provided that the maximum level of detail of the reports is the month and not weeks or days.
In case your requirements cannot be fulfilled by month-related calculations at the month granularity, then you should use another pattern. Check the
introduction to figure out what is the right pattern for your scenario. Time-related calculations
Student Reviews (3)
Carlos Barboza (Feb 20, 2021) Excellent course for those who need implement custom calendars. For example, for our accounting fellas who sometime recur to 13 months period evaluations. Richard White (Dec 21, 2020) Great video Refa Abay (Oct 24, 2020) Everything explained so comprehensively that I would like to thank you once again.
What is included
This video course contains 71 minutes of training, for a total of 10 lectures.
Our training platform
tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
+ $400 10% + $800 15% + $1000 20% + $4000 25%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
button and add more students in the next step.
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
A team management dashboard is available if you choose to assign this course after the purchase or you get a
Use this tool to assign your licenses and monitor the study progress of your team.
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!