Aims & Objectives

Most reports include dates so information can be aggregated over various calendar periods, years, months & days for example. This session includes reporting at a calendar and financial year end. In this session you will learn the importance of creating a dates table and how to connect it to the data model.

This session is designed to complement sprint 2 but can also be run independently. It is ideal for users who are confident at building Power BI reports, but want to extend their knowledge to working with dates and other calendar periods. A basic understanding of how a data model works is helpful.

What will I learn?

Working With Dates

  • What is a dates table & why do you need one?
  • Construct a dates table from scratch using the ‘M’ script provided.
  • How to format and configure the dates table to ensure information is presented correctly.
  • Make sure the dates table spans the period of the data in the data model.
  • How to modify the dates table so you can easily report on periods such as, yesterday, today & tomorrow.

How We Deliver

We currently deliver all training online to comply with the Government's guidelines.

Online training works well for businesses whose staff are mainly working from home.

It allows us to train all of your staff with the same training needs at the same time. Your people simply log on from home, using details provided in advance by our team.

Choose from Watch and Learn sessions for larger groups or interactive hands on sessions for smaller groups.

When permitted we also offer face to face training at your offices.

All sessions can be customised to a half day or 90 minute sprint session and tailored to fit your needs, covering the topic(s) within a course that are most important to your business.

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)