Date table does not work well with my data

[Niels_T]

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:

[amitchandak]

@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_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:

[Niels_T]

Thank 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 · Accepted solution]

@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