Forum Discussion
Post PatronDate table does not work well with my data
I've tried to make a date table in Power BI using a tutorial.
I then connected the relationships but for some reason my date table does not work.
Whenever I select a month the data goes blank or doesn't update.
This is the date table itself:
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
4 Replies
- amitchandak
Super User
Niels_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: