Forum Discussion

BUK2020's avatar
BUK2020
Frequent Visitor
6 years ago

Forecasting with irregular dates

I am trying to forecast, but recieve the message that my data is too irregular to do so.   Having looked at past solutions i can see that this link shows how to fix the issue: http://www.erikhudzik...
Need Help
ibarrau's avatar
ibarrau
Super User
6 years ago

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,

BUK2020's avatar
BUK2020
Frequent Visitor
6 years ago

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.
  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    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.

    • BUK2020's avatar
      BUK2020
      Frequent Visitor
      6 years ago

      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? 

       

       

       

       

      • BUK2020's avatar
        BUK2020
        Frequent Visitor
        6 years ago

        This is strange...

         

        So i added my date (from date table) and revenue into a visuals table, then made sure the table was showing items with no data. Then i converted this to a line chart, which still has "show items with no data" checked, but on the chart itself it is excluding all dates with no data.

         

        Is there any reason for this? as far as i can see it should be showing all items.