Excel 2016 DAX Error: "We couldn't get data from the model..."

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  July 7, 2016 at 9:56 pm

  #328101

  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