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 previous month base on the Date column (confirmed Date Type format) and this value is called 'Lease Payment (Cash Basis)'. This is the DAX formula we are using: =CALCULATE( MIN('Table'[Value]), ALLEXCEPT('Table'[Value2]), PREVIOUSMONTH('Table'[Date].[Date]) ) Action 2 - I am using the approach found if you Google “Currency conversion for Power BI and SSAS” by Kasper On BI. I tried to input the URL via the LINK tool and directly as text, but it appears to be causing an issue. Both of these approach work for me separately. But when I create the required relationships for Action 2 as shown below, I get the error message for the DAX formula in Action 1, also shown below: