Forum Discussion
kasife
Helper V
Helper VFilter last 3 months
Hi people, Guys, I'm trying to bring values from the last 3 months into a matrix and for that I used this filter I filter the last 2 months and include today because I need the current...
parry2k
Super User
Super Userkasife the reason it is not working is because you didn't mark the calendar table as a date table. Once you do that, everything will work.
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Time Intelligence Playlist