Forum Discussion

pokdbz's avatar
pokdbz
Icon for Helper II rankHelper II
7 years ago

PBI vs SSAS 2017 DAX error

Below is a measure that I have in a SSAS 2017 tabular model.  In Visual Studio it shows an error on the measure.  But the measure functions correctly when built.

Error: An invalid numeric representation of a date value was encountered

 

When I put this exact measure in Power BI Desktop as a measure there is no error. 

Why is SSAS showing this measure as an error, and is there a way to fix it so the error message doesn't come up in Visual Studio?  Is this measure written correctly?  I'm not exactly sure what the error means.

 

Sales 4 Week Agg:=
CALCULATE (
[Sales],
DATESINPERIOD (
'CALENDAR_DAY_PLUS_MV'[NEW_DAY_DTE],
LASTDATE ( 'CALENDAR_DAY_PLUS_MV'[NEW_DAY_DTE] ),
-28,
DAY
)
)

1 Reply