Forum Discussion
Post PatronDate table does not work well with my data
Niels_T , Assuming created at is text. If it is date just change the format and check . If it does not have a timestamp, it should work well with the date table
Create a new column
Date = "01 " & [created at]
Change data type of this column to date and join it with date table. and Try TI
Super UserNiels_T , For that we need to know more about another table, Like the date has a timestamp, Date table is not complete.
I have discussed in detail 5 main things you need to take care to make Time Intelligence successful.
See if those can help : https://www.youtube.com/watch?v=OBf0rjpp5Hw
Niels_TThank you for your reply Amit,
I'll check out your video.
Right now my data from the fact table (created_at) is formated like this:
The date table I made is shows the dates like this:
- amitchandak
Niels_T , Assuming created at is text. If it is date just change the format and check . If it does not have a timestamp, it should work well with the date table
Create a new column
Date = "01 " & [created at]
Change data type of this column to date and join it with date table. and Try TI
- Niels_T
Another thing I've noticed is when I make the Sales YTD
$
And I add them together with the date table it also doesn't give me any data: