Forum Discussion
Data filtering
So, when we're filtering all data from day, month, and year (selecting all function). Now, 5 out of 6 visuals are filtering data but 1 isn't doing that. Below attached is the query used for filteri...
does your data model consist of date table? If not, Ensure that your ActualDate table is linked to your date table in the data model.
MTD Sales = CALCULATE([Sales], DATESMTD(DATEADD(ActualDate[Date], -1, DAY)))
OCAC master data actual date (column), is not connected to table calendar dates(Column).