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

Going to try and make this simpler:

 

 

Hopefully these diagrams should be really clear as to whats happening with my data :(

 

Let me know

 

Thanks

 

Voose

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

Voose nothing sticks out as obvious to me

 

but maybe it would  be best to create the min and max of the calendar date based on the opportunity created date (im assuming that what your if column is made up of) because based on what you said previously that should be the combo of the 2, rather than creating it on min of historic and the max of opportunity snapshot.

 

 

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