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(...
Anonymous's avatar
Anonymous
Not applicable
6 years ago
All time-intel functions necessarily need a proper Date table. A proper date table has a column with dates in it which are continuous, unique and cover full years. Just create such a table and connect to your fact table. Everything will then work perfectly well. If you really want to create good and correct models, please structure your data as a star schema. Power BI has been designed to work with star schemas in the best possible way. You can even read this in the official documentation.