Forum Discussion
Date Relationship Problem
I have a problem with something that seems like it should be very simple. I have a Dates table initially generated by AUTOCALENDAR() and also a Consumables table with ID and Dates Used columns. When I try to relate the Date Used in the Consumables table to the Date field in the Dates table, I am unable to get a count by date in the report view. See pictures.
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.
8 Replies
Hi everyrichrole,
It would be helpful to have a picture of your data, but my first steps would be to set both of your date fields to the Date or DateTime type, and make sure they're in the same format (e.g. both DD/MM/YYYY, etc.).
Hmm, your dates don't look out of alignment. Could you share your PBIX via dropbox/onedrive/etc.?
