Tag: Power Query Date Table

Creating A Date Table In Power BI The Fastest Way Possible

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

I’m going to show you a new approach in creating a date table in Power BI. You may watch the full video of this tutorial at the bottom of this blog. 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

Continue reading

Convert The Date Table Function Into A Table Query In Power BI

I’m going to show you how to turn an M code for a date table into a table query. You may watch the full video of this tutorial at the bottom of this blog. I would consider the level of difficulty for this tutorial as intermediate because if you have any experience with M codes,

Continue reading

M Function For Date Table – How To Add A Parameter In The Query Editor

I’m going to show you how to add a parameter in the M function in your date table query. This example is based on a question that was raised on the Enterprise DNA Forum. You may watch the full video of this tutorial at the bottom of this blog. The question was about how to

Continue reading

Data Masking For Sensitive Information In Power BI

In this tutorial, you’ll learn how to perform data masking for sensitive information in Power BI using Power Query. You may watch the full video of this tutorial at the bottom of this blog. Data masking allows you to hide or remove confidential or identifiable information in your Power BI data models. The discussion will

Continue reading

Creating Values For Each Date Using Power Query Formula

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

Continue reading