Add rows to Power BI dataset for date range

Posted On October 17, 2021 by Aditya Somwanshi Posted in  Tagged in

Hi in this blog we will see how we can add rows to power bi dataset for a given date range.

For example if you have a dataset which has start and end date and you want rows for each date between this range then this blog will help you.

Step 1:

Open Power BI load your dataset and go to transform data. Right click on your from date column and change its type to date.

Step 2:

From add columns click on custom column

Step 3:

In custom column formula add following code:

{ Number.From([From])..Number.From([To]) }

Step 4:

Expand this column to new rows to get your result.

Step 5:

Change the datatype of this column to date.

In this way you can prepare your dataset for all the dates present in your From and To column.

Hope this helps.

Share Story :