Forum Discussion

everyrichrole's avatar
everyrichrole
Frequent Visitor
8 years ago
Solved

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 ...
Need Help
  • everyrichrole's avatar
    everyrichrole
    8 years ago

    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.

everyrichrole's avatar
everyrichrole
Frequent Visitor
8 years ago

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.

meorir's avatar
meorir
Frequent Visitor
7 years ago

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