PBILAS Logo 2h
The future of Live Interactive Learning: ½ day sessions using Zoom - with the topics you need - just when you need them.
We NEVER cancel a course - even if there's only one attendee!
No scheduled course when you want it? Easy - just schedule one on the dates you prefer!
Maximum class size of 6   +   Short ½ day sessions   =   Better learning outcomes + Less time away from work.
Independent instructors with lower overheads = Better value for money options.
Cancel or reschedule up to 24 hour in advance + Money back guarantee = NO RISK! 
Free and indefinite post-course support from your instructor = We care about and support your learning journey all the way.

Advanced Modelling with M

Learn how to use the M language to add more complex calculations and perform advanced transformations.

In this course you will learn:

  • About the M language in more detail.
  • A range of useful M functions.
  • How to perform advanced calculated columns with M, including performing lookups between tables.
  • How to perform advanced transformations with M.
  • How to creating custom M functions and applying them in Power Query.

Current Scheduled Courses

Click Book New to schedule a course on your preferred dates.
Seats: 6
Book New

Pre-course Requirements

Required knowledge. Before attending this course you must have met the following pre-requisites:

  1. Completion of the Power BI: Kickstarter (Level 1) course AND have practiced using Power Query for a range of transformations.
  2. Have an intermediate level knowledge of some type of formula language such as DAX or Microsoft Excel formulas, or some other programming language experience. This is required so that you have a good understanding of programming logic and how functions work, which is assumed knowledge for the topics in this course.

Useful knowledge. The following skills and knowledge might be useful, but are not essential to have. We cover these topics in the course, but knowing a little about these topics may give you a head start.

  1. Have attended the Power BI: Multi-source Data Modelling (Level 2) course, so that you have a more advanced understanding of modelling best practices and more advanced Power Query techniques, however this is not a required pre-requisite.

Pre-course learning topics. There are some pre-course learning topics to complete in the form of videos with cheat sheets. These are important to watch as they are assumed knowledge for the course and are only covered in revision in the sessions. These will be sent out to the participants after the booking is complete.

Pre-course Setup Checklist. There is a pre-course setup checklist which you must complete before your first session to ensure you have the correct software and hardware installed and configured before you can attend the course. This will also be sent out to the participants after the booking is complete.

Training Resources

The following resources are provided as part of this course:

  • Cheat sheets. Core concepts and some 'how to' guides are provided in cheat sheets to help apply the knowledge and skills back in the workplace.
  • Exercise files. Class exercise files and data sources are provided, which are used during the sessions and which can also be used for further practice after the sessions.
  • PowerPoint Slides. A copy of the PowerPoint slides used throughout the course will be provided so that participants do not need to try and copy slides, or write extensive notes throughout the course.

A link to download the training resources in 'zip file' format will be sent out to students after booking for the course. These files will need to be extracted prior to the first session.

What's next?

The following courses can also be completed following this course and provide more skills and knowledge in creating DAX Measures and Report Design:

For the full Power BI course offerings and pathways click here.

Course Categories

Product: Microsoft Power BI
Category: Data Modelling
Level: L3 Advanced

Duration, Participants & Price

Duration: 1 x 3 hour session.
Class size: Maximum of 6 participants.

Pricing: is shown below and depends on the number of participants booked.