Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
Missing a parentheses to close the MAX function. This should work:
Amount_SameMonthLastYear_MTD = CALCULATE( [Amount_MTD], DATESINPERIOD( DimDate[Date], EOMONTH(max(DimDate[Date],-13)+1, 1, MONTH ) )
What about this?
Amount_SameMonthLastYear_MTD = CALCULATE( [Amount_MTD], DATESINPERIOD( DimDate[Date], EOMONTH(max(DimDate[Date],-13)+1, 1, MONTH ) )
I get "the syntax for 1 is incorrect"
Missing a parentheses to close the MAX function. This should work:
Amount_SameMonthLastYear_MTD = CALCULATE( [Amount_MTD], DATESINPERIOD( DimDate[Date], EOMONTH(max(DimDate[Date],-13)+1, 1, MONTH ) )
Sorry, still doesnt work, get the same error.
Cant see any difference in the 2 code snippets you posted, tried to add a paranthesis after the max function but still the same errror.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |