Forum Discussion

khaycock's avatar
khaycock
Icon for Helper I rankHelper I
6 years ago

Date Relationship not working

My date relationship isn't working between my two tables and I can't figure out why!

 

They are both the same data type and format:

 

And the relationship is exactly what I would expect it to be..

 

 

Have I missed something??

Need Help

3 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi khaycock ,

     

    If I see your screenshot, I see that Power BI has crrectly identified a MANY-to-ONE relationship between both tables.

    Just wanted to understand why you think the relationship is not working?

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    khaycock , There can be a couple of reasons. Form completion time has a datestamp and visible because of format. Change to datetime and format that has time and check. If has tome other than 12 AM. create a date field and join that

     

    Form completion Date =[ Form completion time].date

     

    Second that you might have used all or crossfilter in the formula. that can cause that

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi khaycock ,

     

    Please tell us why you think "Date Relationship not working"? Is there a specific performance?

    Please provide some sample data and screenshots. Please remove sensitive information.

     

     

    Best Regards,

    Icey