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

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

is your relationship of your calendar date mapped to opportunitydate?

 

does the calendar date include all dates from opportunity date

  • Voose's avatar
    Voose
    Helper III
    9 years ago

    YEp it is mapped to that date, and the calendar object is made up of Min(opportunity date) and Max(opportunity Date)

    • Voose's avatar
      Voose
      Helper III
      9 years ago

      IF I change the parameters of the If statement to = historical date

       

      It pulls through the date fine using the relationship as expected,

       

      If I change the parameters of the column to = createddate 

       

      Nothing pulls through

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        9 years ago

        that is strange, if you created the opportunity date in power query rather than dax in a calculated column would that make a difference maybe?