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
Tag: Formatting Ideas Power BI
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
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