Have You Ever Seen This Cryptic Error? Here’s a Quick Explanation and Fix
So you’ve got a DATEADD measure…
Let’s say you’ve written a nifty measure called [Last Year Sales] that returns the sales value you had one year ago at the same time:
[Last Year Sales] =
CALCULATE([Total Sales, DATEADD(Calendar[Date], –1, Year))
And hey, that works great:
So far so good: [Last Year Sales] Measure is Working Great!