Tag: Power Query Date Table

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. Data masking allows you to hide or remove confidential or identifiable information in your Power BI data models. The discussion will focus on these points: And this basic model will be used as the example: When

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

Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables

I’ll show you how to set up dynamic start and end dates when you’re using power query date tables. If you’ve been following this series on different Time Intelligence subjects, you already know how to create a date table using power query functions. You might have also read about how to change the end date

Continue reading