Forum Discussion

thethakuri's avatar
thethakuri
Frequent Visitor
5 years ago

Date dimension table not working with Generate(d) table

I have following tables: sales_target (from DB) wip_forecast (from DB) DateDim (date dimension table) Cashflow Forecaster (created from another table using "Generate")      All dates a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Assuming you are expecting to see dates in the future (hence the Forecast), do you have future dates in your date table? And what are the relationship fields from Date Table to forecast table? Finally, can we see the formula you are using?

Thanks!-- Nate