Problems with created time values

[Anonymous]

Hello, everyone,

I have a problem. I created a date table as usual and created a relationship with my dates. (Date to Date) When creating a table, the date values from the date table are not displayed.

ps: Sorry for the inaccurate description of the problem

Thanks for Help

[Anonymous]

Hello Amitchandak,

thanks for your support.

So far I have taken everything into account, but I cannot explain one phenomenon.

Every time I create the relationship, my data table is no longer marked as a date data type.

1.

2.

The formats are all created correctly, but the evaluation in a table does not work.

[Anonymous · Accepted solution]

Hi @Anonymous ,

According to your screenshot, I think the month in matrix column field is created by Time intelligence.

As far as I know, the date hierarchy by Time intelligence in fact table will be destroyed. In your screenshot, we can find this.

If there is no relationship between "Abfrage1" and "Kalendar", date hierarchy for [DateCreated] works.

If there is a relationship between two tables, only date hierarchy in dimdate table will work.

In my side, I can reproduce your issue.

Here I suggest you to use date hierarchy from dimdate table instand of data table.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , There can be 6 reasons, refer my blog or video

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4