Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
6 years ago

DATEADD error message for visuals

    I created 2 measures, Current Year MTD Sales and LYMTD Sales.   LYMTD Sales = CALCULATE([Total Sales],DATESMTD(DATEADD('ORDHDT01 (2)'[Fiscal Dates],-12,MONTH))) MTD Sales = TOTALMTD(...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago
Is this table ORDHDT01 (2) a calendar table with all the dates for whole calendar/fiscal year? Also if you are not slicing data by dates then also you will get the same error. Remove every field from the visual apart from the columns coming from the dates table.