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
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Hi Nate,

 

My dates table have dates ranging from April 2008 to 10 years in future (June 2022), more than enough for forecast table.

FILTER (
    CALENDAR ( MIN ( 'invoice'[date_issued] ), DATE(YEAR(NOW())+10,MONTH(NOW()), DAY(NOW()))),
    [Date] = EOMONTH ( [Date], -1 )+1
)

Here's the relationship fields from Date Table to forecast table:

thethakuri_0-1624834834393.png

Forecast table:

CashflowForecast Table = GENERATE ( 'FilteredQuote Table', GENERATESERIES ( 1, 'FilteredQuote Table'[forecast_months], 1 ))
FilteredQuote Table = CALCULATETABLE('quote',FILTER('quote','quote'[stage]<>"Archived"&&'quote'[stage]<>"Deleted"))