Creating a Date Table That Populates Date Ranges Between Start and End Dates

Question

Hello everyone,&nbsp;&nbsp;New Power BI user here!&nbsp;&nbsp;I have a table that contains this construction data:&nbsp;&nbsp;&nbsp;I want to creat a new date table that has&nbsp; dates in between the start and finish dates.&nbsp;&nbsp;Example:&nbsp;&nbsp;I want to use this table to creat a visual like this, but with a much smoother curve.&nbsp;&nbsp;Any help would be appriciated!&nbsp;&nbsp;

amitchandak · Accepted Answer

Jacob_Fetter , Refer 
DAX Dynamic - https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785
DAX new table - Attached file -
&nbsp;
Power Query - Get Dates between ranges using Power Query: https://youtu.be/SFEPsKfqIks

Forum Discussion

Creating a Date Table That Populates Date Ranges Between Start and End Dates

2 Replies

Related content

Population dynamic graaph

Creating ICMs via Activator

Creating relationships

Create new table

Populate a Tooltip from a Data Dictionary