Forum Discussion

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

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

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)

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
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?
- Voose
  Helper III
  9 years ago
  How would I create it in Power Query? -> Edit Queries then? - I can't merge it with my Calendar tables as obviously thats a calculated table :(
  - vanessafvg
    Community Champion
    9 years ago
    what i would do is first try and figure out why the date is not working in the one you have created i.e create 2 columns opporunitydate 1 and opportunitydate 2 one without createddate and one with and see where the differences are and see if you can correct it in the if statement.
    
    it is hard to figure out what the issue is without seeing the structure of your tables, if you could post a screen shot of your relationships that might help.
    
    the power query option is for me a better option because its shaping the data how you want it, i.e create calculated column exactly like you have in dax in the table you currently have it, unless the table its created in now is the calculated table that is calculated in dax not power query ? i.e in power query add column / create custom column and then have the same if statement i.e
    
    if historical date = "" then createddate
    else historicaldate
    
    i am not sure what difference it would make but it might.