What will I learn?

This session covers more advanced use of DAX including IF, CALCULATE, FILTER, ALL.  Calculating percent of totals, using DAX to remove repeating values and create dynamic text.

You’ll also learn to use DAX formulas that reference more than one table.

We also take a detailed look at date calculations and the important associated time intelligence functions.

This session is designed to complement our DAX sprint but can also be run independently.

The session is designed for users who are confident at creating basic DAX formulas and building Power BI reports but want to extend their knowledge to working with for more complex DAX formulas including time-intelligence calculations.

It would be helpful if the user had a basic understanding of how a data model works.

  • Further DAX and Working with Dates
    • A closer look at CALCULATE related functions
    • Modifying the filter context in a DAX formula
    • What a dates table is & why you need one
    • Learn about DAX Time Intelligence functions and how to use them in financial reports.
    • How to modify the dates table so you can establish a custom reporting year (for example, starting in April).

What’s Included in Our Sprints?

We pride ourselves on delivering first class training that meets your staff’s needs. Here’s what to expect:

  • Your own booking specialist to help you choose the best training for your needs.
  • A choice of online or face to face training, delivered by our friendly and highly experienced trainers.
  • Free pre-course IT skills assessments to help establish which level of training is required.
  • Lots of interaction and practical examples to keep everyone focused and to embed learning.
  • Post-training support from certificates, user guides, workbooks and a summary of the delegate feedback.

Why Choose To Learn With TrainingU?

We’ve helped hundreds of mid-level and blue chips train all their team members since 2006. Got questions? Speak to one of our team now on 0333 344 6630.

Trusted Pair of Hands

Established over a decade ago, we are a team of knowledgable training and software rollout experts.

We Love What We Do

We are passionate about delivering excellent training and software rollout support that makes a real difference to you and your teams. We strive to exceed your expectations in all that we do.

Personal & Bespoke Service

We pride ourselves on listening and offering a personal and reliable service to each and every client that we work with. We seek to build a strong and lasting relationship and to become your go-to training partner.

Experts in our Field

Our trainers are experts in their subject matter, bring a wealth of experience and have a natural ability to make everyone feel comfortable and to bring out the best in learners.

To discuss your requirements
in more detail