Forum Discussion
Calendar relationship issues
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?
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 :(
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.
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
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.