Forum Discussion
Solved
Last month
Hello, I am pretty new to dax and your help will be appreciated. I have a table and I need to filter the data from this month. I have no clue how to do it. thanks in advance!
astridaku You can accomplish this by adding a calculated column to your table. Use the following dax calc and set your outputs to identify the current month.
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), "Current Month", "Other")
or rather than text I usually just use bits 1,0 if I'm just filtering on the back end (not in slicers)
IsCurrentMonth = IF(MONTH(test[Date])=Month(NOW()), 1, 0)
Then in your page/report/visual you can filter to only show current, or use a slicer
thanks so much!!!
it worked
astridaku If the solution is working for you please mark it as Answered in order to help other community members.