DAX Patterns: Custom time-related calculations
These are in-depth video lectures of the
pattern. Custom time-related calculations
This pattern shows how to compute time-related calculations like year-to-date, same period last year, and percentage growth using a custom calendar. This pattern does not rely on DAX built-in time intelligence functions and can be used in those cases where a calendar does not satisfy the requirements for standard DAX time-intelligence functions, like when a fiscal year starts on a month other than January, April, July, or October.
To make sure your requirements need a custom time-related calculations pattern and cannot be implemented using another simpler pattern, check the
introduction to figure out what is the right pattern for your scenario. Time-related calculations
Custom time-related calculations
Student Reviews (4)
Carlos Barboza (Mar 8, 2021) mindblowing formulas! loved it and learned a lot ! molto grazie Marco Carlos Barboza (Mar 8, 2021) mindblowing formulas! loved it and learned a lot ! molto grazie Marco Carlos Barboza (Mar 8, 2021) mindblowing formulas! loved it and learned a lot ! molto grazie Marco !!!! Mark Walter (Aug 18, 2020) Excellent and compressive series covering different custom time scenarios. I always learn something new from Marco and Alberto that applies directly to my job.
What is included
This video course contains 100 minutes of training, for a total of 9 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.
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!