Forum Discussion

Voose's avatar
Voose
Helper III
9 years ago
Solved

Calendar relationship issues

Hi All,   I'm trying to pull a basic data through my calendar so I can see values over time.   I have a Calendar table that calculates by taking the min and max value of my date field.    My op...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Voose,

    Please review my reply in this similar thread, the above issue could occur when you change the format of the opportunity Date field from DateTime to Date, in this scenario, not all the datetime values in your opportunity table match the date values in your calendar table.

    Regards,
    Lydia Zhang

Voose's avatar
Voose
Helper III
9 years ago

Done & Still no solution :(

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

If you want to post your pbix here i can have a look at it but i think you probably have to dig into your date field to find the issue, something isnt tallying up, personally i would push this sort of tranformation into power query.