560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Ways to model different DAX calendar date situations Part one of a six-part series of blogs |
---|
In the real world (or at least, the DAX version of it), calendars and dates aren't quite as simple as one would like. This blog shows how to solve a number of common scenarios, including where different tables have different levels of "granularity", coping with special days like bank holidays, handling non-standard finanical year-end dates and dealing with a table which contains more than one date column.
This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources. |
The previous blog in this series showed how to create and use a basic calendar. This blog shows how to cope with the following scenarios which can arise in "real life":
Scenario | Notes |
---|---|
Varying date granularity | How to cope when some data is at date level, some by month and some by quarter. |
Bank holidays | The best way to integrate special days like bank holidays into your calendar. |
Financial years | Coping with the common scenario that your financial year doesn't end at the same time as your calendar year. |
Multiple date tables (1) | Using multiple tables to cope with the situation where a single table contains two or more dates (for example, an order table might have an order, shipping and invoice date). |
Multiple date tables (2) | Using multiple relationships as a way to model the same thing, but this time including your calendar table only once. |
Even if your interest in calendars is waning it's still worth reading this blog, as many of the techniques introduced have much wider application within SSAS Tabular.
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2023. All Rights Reserved.