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 filtering and visuals screenshot is attached.
4 Replies
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).
DATESMTD & DATEADD are time intelligence function. Make sure your data model supports these time intelligence functions. For example, you need a continuous date column for these functions to work correctly. So please create a date table and reference the date column from that in your query.
can you please connect with us on google meet link? so we can better understand
