Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Column reference to 'Date' in table '...' cannot be used with a variation 'Date'

Hello, I am running into an error that occurs when I try to couple two different actions in Power BI. Action 1 - I am creating a new column that finds the corresponding value for the same day the prev...
Error due to relationship
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for bringing the importance of the CALENDAR table to my attention. 

 

I have gone ahead and created this table in my model.  Then in the relationship (attached in original message) I put this table between the Lessor/Lessee Data table and the Exchange Data table connected by the date fields.  The same error persists, however.

 

Is this error message one that you would expect to find if the CALCULATE function is causing the custom column to time out/stop?

 

 

Thanks,

Alex

Anonymous's avatar
Anonymous
Not applicable
6 years ago
ExchangeDate is completely unnecessary. One of the reasons is the 1-1 connection between this table and Calendar.

Best
D