Tag: Formatting Ideas Power BI

Calendar Layouts To Tabular Format Using Power Query

Tabular-Format-Using-Power-Query

In this tutorial, you’ll learn about turning multiple calendar type layouts into a tabular format using Power Query in Power BI. You’ll learn how to transform multiple files instead of a single file from a folder. This tutorial will also teach you how to fill gaps in your data and how to harvest them in

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

Formatting DAX Code In Power BI

Effort here will pay dividends later Placing effort into formatting your DAX code will make a huge difference as you build out your data models in Power BI. DAX, at times, is a confusing language, as it is. So as soon as you get into the slightly complex territory, unformatted DAX code becomes almost impossible to

Continue reading