skip navigation
skip mega-menu
17 April 2026 12:15 - 13:15
The M language (Mashup to its friends) is automatically written when creating steps in Power Query. There are some tricks that you can do that aren't available using the menus.


Wise Owl welcomes you to this lunchtime webinar, showing you some tips and tricks with the M language.

Sample of M query language

This script removes empty columns from tables.

M is useable in Excel and Power BI Desktop. Let us show you how!

Date

17th April 2026

Time

12:15–1:15pm (perfectly timed for your lunch break)

Location

Online via Teams


Below is a list of topics that we will cover during the 1 hour session. The goal is to learn some use cases for the M language.

Topic

What we'll cover

Introduction

  • Overview of Power BI

  • Licences

  • What do Wise Owl use it for?

Tables

  • Using array structure

  • Generate table list

  • Convert to combined table

Unpivoting groups

  • Grouping Columns

  • Combine grouped tables

  • Generate group index

Other tricks

  • Buffer with duplicates

  • Add missing columns

  • Remove blank columns

Wrap-Up & Q&A

  • Recap key takeaways

  • Share resources

  • Invite questions

  • Suggest next steps

You can sign up here to receive a message about this and future webinars. You’ll get an email with your Teams invite, and we’ll see you at lunchtime on Friday 17th!



Free
17 April 2026 12:15 - 13:15 Online

Subscribe to our newsletter

Sign up here