I have a pretty small data set in Excel 2016, and I'm trying to create a really simple measure
=CALCULATE([Total Sales],DATEADD(Calendar[Date],-1,MONTH))
(Total Sales Previous Month)
When I try to save it, I get the "couldn't get data from the model..." How do I fix this? I tried closing the file, reopening, recreating... all failed. It doesn't seem to matter how I set the data types.
The odd thing is that the exact same formula works if I change MONTH to YEAR. This measure works:
=CALCULATE([Total Sales],DATEADD(Calendar[Date],-1,YEAR))
Any idea how to fix this? (Do I really have to start over again???) Not a huge deal if I do, just kinda annoying.
FWIW...
Version 16.0.6925.1018 64-bit
Thanks!
Pieter