Forum Discussion
Problem with date
I have 2 tables that each have a column of dates. I have created the calendar table that has a relationship with the 2 columns. Until now the data was updating fine but when I filter for 2022 I don't get any information. Any idea what is going wrong?
All columns have the same Data type.
Thank you in advance for your help.
Anonymous your date 1 and date 2 contains time information in it, in PQ, you need to change the type to date or separate date and time columns, and then it will work.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.
6 Replies
Anonymous your date 1 and date 2 contains time information in it, in PQ, you need to change the type to date or separate date and time columns, and then it will work.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.
Thanks parry2k for your quick reply.
I changed the date format but it doesn't work. What I don't understand is why I can see graphs for all previous years but not for January of this month?
Can the dates be repeated in the 2 columns?
Anonymous when you said changed the date format, did you change the type in PQ or date format. these are two different things.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
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.
Thanks parry2k for your help!