Forum Discussion
Date Relationship Problem
Unfortunately, I can't release the PBIX without also giving out a bit too much information about our data sources. I can tell you that I tried creating a new calculated column in the Consumables table with =DATEVALUE(Date Used), and I was able to get the relationship working by using that column. So I suspect this may be an internal bug with the date type/format casting of the Date Used column.
Hmm, your dates don't look out of alignment. Could you share your PBIX via dropbox/onedrive/etc.?
Unfortunately, I can't release the PBIX without also giving out a bit too much information about our data sources. I can tell you that I tried creating a new calculated column in the Consumables table with =DATEVALUE(Date Used), and I was able to get the relationship working by using that column. So I suspect this may be an internal bug with the date type/format casting of the Date Used column.
Glad to hear it's fixed! Go ahead and mark your own comment as the solution.
I had the same problem, DATEVALUE solution works nicely, what worked for me also was changing data type during import from date/time to date only.
Maybe someone will find this useful.
Best regards
Thanks a lot, this solution worked for me as well, Before using this solution i wasted almost 5/7 hours but not able to reach the desired results with RELATED function output, finally got this solution and it worked :)
Thank you! That solved my Problem too! 🙂
