Forum Discussion
Problems with created time values
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
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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-bd52912a5bd4Hello 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.
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
