Power BI Expanding dates inside of a date range

[Brady-Linnebur]

Hello, I have a dataset that I need to expand date ranges on. The data has campaigns that only run during certain time frames. Also, some of the items are also on the normal daily list and still can be sold outside of the campaign date range. I just want to display, however the dates inside of the campaign and the amount of items sold inside of it. I want a linear date range that will display all dates inside of the date range even if the dates are in the future.

Let me know if you need more clarificaiton on anything and I will respond as soon as I can!

Thanks for the help!

[Ashish_Mathur]

Hi,

Not sure of what you want.  In the Query Editor, write a custom column formula

={Number.From([Campaign Start Date])..Number.From([Campaign End Date])}

Expand this column.  This will explode your table into one row for each date which falls in the range.

Hope this helps.

[Brady-Linnebur]

Say the date range is from 8/30/23 - 9/10/23, the dates from 8/30 - 9/6 will be populated since those dates have already happened. I want to also display dates in the future that have not happened yet. I am trying to build a prediction where I can see for an example that 9/8 will sell 2x than 9/3. But I can't quite seem to get dates to populate in the future.

[amitchandak]

@Brady-Linnebur , refer these ways

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

[Brady-Linnebur]

That is a start so thank you for the info above so far. I also want to have future dates that havent happened yet becuase I want to use predictions for those future dates. Would you mind elaborating on this for this?