Add rows to Power BI dataset for date range
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.
Related posts:
From Project Operations to Business Central: Following the Data Behind Project Financials
Location-Based Item Based Visibility in Business Central for a Maldives-Based Marine Services Firm
Connecting Project Operations to Finance: Our Dataverse-to-Business Central Integration for Project ...
