topic Re: Creating a Date Table That Populates Date Ranges Between Start and End Dates in DAX Commands and Tips

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

Jacob_Fetter — Thu, 30 Jun 2022 18:28:59 GMT

Hello everyone,

New Power BI user here!

I have a table that contains this construction data:

I want to creat a new date table that has dates in between the start and finish dates.

Example:

I want to use this table to creat a visual like this, but with a much smoother curve.

Any help would be appriciated!

amitchandak — Fri, 01 Jul 2022 03:37:01 GMT

DAX new table - Attached file -

Power Query - Get Dates between ranges using Power Query: https://youtu.be/SFEPsKfqIks

Jacob_Fetter — Fri, 01 Jul 2022 14:08:48 GMT

Thank you for providing me with those materials! I was able to get the result I wanted by using them.