I’m going to show you a new approach in creating a date table in Power BI. I’ve done so many tutorials about creating date tables over the years, but the new method I’m using now is, by far, the most efficient way to do it. This is actually an approach created by Melissa, one of
Tag: Date Table Power BI
In this tutorial, we’ll learn about staging queries using Power Query editor. This is a new concept that I’d like to discuss for us to have an understanding of when and where we can use this in the query editor. Staging queries can be used to configure and expose the data sources parameters to the dimension and fact table queries of the dataset. For Power BI datasets,
I’m going to show you how to turn an M code for a date table into a table query. I would consider the level of difficulty for this tutorial as intermediate because if you have any experience with M codes, it would be easy for you to follow along. If you don’t have any related
I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.
In this tutorial, you’ll learn how to create values for each day using Power Query formula in Power BI. Creating values for dates is an important technique to learn in Power BI. It can give you the data you want to see throughout the days in your model. This technique also covers the gaps between