Forum Discussion
Problems with the table relationship
Dear Community,
I have a peuqeño problem but I have not been able to solve because I can not find the error.
I have a table that has a creation time column where a date with a time exists
and I generated another table with the calendarauto() function
The issue is that I make the relationship between the tables through the columns mentioned but when trying to graph something, nothing appears 😞
This is a failed attempt at graphing
What am I doing wrong?, I have seen myself as 3 tutorials and in all I do the same steps and I do not achieve that the relationship allows me to graph correctly
Syndicate_Admin the relationship will not work if the date column in your transaction table contains time with date, calendarauto created a date column with a midnight time stamp. You need to change the data type to date in PQ for your original column or create another column and extract date from date/time column and then set relation on this new column., and that will fix the issue.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
4 Replies
Syndicate_Admin the relationship will not work if the date column in your transaction table contains time with date, calendarauto created a date column with a midnight time stamp. You need to change the data type to date in PQ for your original column or create another column and extract date from date/time column and then set relation on this new column., and that will fix the issue.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thank you very much, I have duplicated the creation date column and in the duplicate I have extracted only the date, this duplicate column that only contains the date I have related it to the calendar table and now it allows me to graph correctly. Thank you for the solution. 👌
Syndicate_Admin so your issue is resolved or not? Not clear from your reply. If it is , please accept as solution so that others can take help from it.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I edited my previous comment, I don't think I explained it well. The problem is fixed and marked as solved, thank you very much.
