Forum Discussion

astridaku's avatar
astridaku
New Member
10 years ago
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!
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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