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.

RMDNA's avatar
RMDNA
Solution Sage
8 years ago

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.).

  • everyrichrole's avatar
    everyrichrole
    Frequent Visitor
    8 years ago

    Thanks for your reply, RMDNA. Those are the first things I tried. Here's a couple pics of the data.

     

     

     

     

     

    • RMDNA's avatar
      RMDNA
      Solution Sage
      8 years ago

      Hmm, your dates don't look out of alignment. Could you share your PBIX via dropbox/onedrive/etc.?

      • 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.