Future Dates not populating when Data is in the rest of the table.

[Brady-Linnebur]

Hello,

I am having this issue, the table below has dates that fall within a date range. This table is related to another table that has sales info inside of it. When writing this post (9/13) we have sales data from (9/11) and prior. The problem I am running into, is it will not populate day of week in the future without sales data being tied to it. I want it to print out all the way through the end of the date range (9/26) even if it is in the future. Any ideas?

[sergej_og · Accepted solution]

So you have a calendar table and fact table (sales), right?
Maybe a possible solution for you is to use the option "show items with no data"?
Rightclick e.g. on Year and check this option.
You should get all past and future data for time period selected in slicer.

[Brady-Linnebur]

When messing with a few items the dates did populate into the future, thanks for the response!

[Brady-Linnebur]

I never knew this and when I saw this reply I was hoping this would be the fix, but unfortunately it still didn't quite resolve it. I am still only visualizing data with dates that have happen. Still need the future ones to populate. Thanks for the reply though, I still learned something!

[sergej_og]

Maybe you can show (sceenshot from excel) your expexted result?
What do you expect?

[Brady-Linnebur]

This is what I am trying to make in PBI from excel. The black cells are dates that already happened, the grey ones are future/forecast.

[sergej_og]

ok, you have a measure to calculate forecast values in your model?

[Brady-Linnebur]

It is currently a calculated column which says when the data is blank (aka grey #) take the columns before it, add them together, then divide that by a set predictive number. This only happens when it is a future date. When it detects data there, the prediction piece does not happen.