Tag: Power BI Power Query

Using The M Function To Create An Extended Power BI Date Table

This tutorial will cover about the most important Power BI dimension table in any model, the Date Table. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension table. A Date Table includes all the attributes that you may want to slice, dice,

Continue reading

Change Date Formats Using The Power Query Editor

In this tutorial, we’re going to go over a quick solution on how to change date formats using the power query editor in Power BI. This is from a recent Enterprise DNA member-only event which featured the production data of an oil and gas company from a certain area in the United States. Inconsistent Date

Continue reading

Changing File Location Using A Query Parameter In Power BI

Changing File Location Using A Query Parameter In Power BI

In this tutorial, you’ll be learning how to share a file with a person that’s not part of your company using a query parameter in Power BI. The data used for this tutorial is a basic stock file containing clothes data. For this example, let’s say you’re working with a person named Bill. Bill is

Continue reading

New Course Release – Advanced Data Transformations & Modeling

Power BI Advanced Data Transformations & Modeling Online Course

You can view details around the new course here – Advanced Data Transformations and Modeling Exciting times here at Enterprise DNA as I’m releasing yet another course into Enterprise DNA Online. The Advanced Data Transformations and Modeling course has been a work in progress for some time as I wanted to make sure that I

Continue reading