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
Post PatronThank 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:
Super UserNiels_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