Forum Discussion
Calculate Function with DATEADD and Filter not working
I have the code for current month, which works well for me. However if I check the DATEADD to -1, the current month row data doesn't show the previous month value in the table visual. Any idea why? ...
if I remove the months filter, the CurrM column now has more than 1 values. I should expect CurrM to only show only the february number when i have DATEADD, 0, MONTH (see image attached)
not sure why i did the same in my model and it wouldn't work. the result is the same as per my original screenshot.
- ray_aramburo
Super User
Why would you need the Data Type column filter on the measure but then add it to the visual?
