Forum Discussion

bourne2000's avatar
bourne2000
Icon for Helper V rankHelper V
4 years ago
Solved

My date table is not working,

Hi   I have sales table which comes from database. It starts from 2012. My sales table as follow     I have created a date table as follow     I connected the date table and sales...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    In the Query Editor, seperate the date and time into 2 columns.  Then create a Calendar Table from the Date column.  Create a relationship from the Date column of the data table to the Date column of the Calendar Table.  In the Calendar table, extract Year, Month name and Month number using calculated column formulas.  Sort the Month name by the month number.  To your visual, drag Year and month name from the Calendar Table.

    Hope this helps. 

HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

I haven't looked at the file but it will almost certainly be the dates not matching because they have times in the Fact table.  So create another column in the Fact table which is just the date (without time) and use that in the relationship.

Let me know how you get on