Forum Discussion
Forecasting with irregular dates
Hi, the calendar or date table is mandatory to time intelligence or this kind of calculations. It is a very good modeling practise too. There are three places where you can create this table like this post shows:
https://blog.ladataweb.com.ar/post/185012464051/data-modeling-como-hago-una-tabla-fecha
It depends on your environment to know where to run it. You should use it, you can't avoid it. With your Date Table related with your other tables you have to use always the date columns of the data table for calculations and visualizations.
Hope this helps,
It seems i am using something similar to the last mode described in the link you provided.
My date table was constructed using DAX:
Date = CALENDAR(FIRSTDATE(ST030100[INVOICE ORDER DATE]),LASTDATE(ST030100[INVOICE ORDER DATE]))The problem i have is that i cannot merge my data table to the ST030100 table as my date table is not a query, it is simply a table created inside Power BI from scratch, using the DAX formula shown above.Just relate the tables together in the relationshops view by Date. Then use the dates columns of date table on the visualizations and the numbers of your table to build this situations.
I tried this, however it doesn't seem to work.
I have connected my date table to my sales table - joining the date fields. so in theory when i add the date value to a line chart it should show every date from the past two years, but it doesnt, hence why my forecasting isnt working.
Is there any reason this wouldnt be working?
