Posts filed under Power Query

(Livestream Replay) Don't be Afraid of the Advanced Editor - with Erik Svensen

One of the first steps of becoming a M-Code Ninja is to master the few elements in the M Language. When you know the basic elements like lists, records, tables, parameters, and functions, the next steps will be a lot easier. In the session we will go through what these elements are and how and where you can use them in order to become a (M)inja. Through a series of demos Erik will get you comfortable with editing your queries so they can be more dynamic and execute with less lines of code.

GUEST BIO 👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 60+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He runs the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his wine shop and his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
Erik's Twitter

Creating Date (Calendar) Hierarchy Columns in Power Query

Video by: Reid Havens

Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.

RELATED CONTENT 🔗

Part 1: Creating a Dynamic Range Calendar Table in Power Query

Posted on October 5, 2021 and filed under Power BI, Intermediate, Power Query.

Creating a Dynamic Calendar Date Range in Power Query

Video by: Reid Havens

Part one of two of my videos on creating a Power Query Calendar Table. In this video we’ll see two methods for creating either a dynamic or relative date range for a calendar table created in the Power Query Editor.

RELATED CONTENT 🔗

Part Two: Creating a Dynamic Range Calendar Table in Power Query

Posted on September 28, 2021 and filed under Power BI, Intermediate, Power Query.

Relationship Issues With DateTime Data Types in Power BI

Video by: Reid Havens

Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.

RELATED CONTENT 🔗

PQ Vs. DAX Data Types

Posted on April 13, 2021 and filed under Power BI, Beginner, Data Modeling, Power Query.