Last month

[astridaku]

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!

[Anonymous · Accepted solution]

@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

[konstantinos]

@Anonymous @astridaku correct me if I am wrong ( I write without testing ) but if you have more than 2 years it will display "current month" for 2 months value. 

Could it be like 

IsCurrentMonth =
IF (
    AND (
        YEAR ( test[Date] ) = YEAR ( NOW () ),
        MONTH ( test[Date] ) = MONTH ( NOW () )
    ),
    "Current Month",
    "Other"
)

[Anonymous]

@konstantinos yep - spot on. Your calc will handle multiple years.

[greggyb]

Or, in Power Query:

// Power Query
// Add custom column
CurrentMonthFlag =
Date.IsInCurrentMonth( [Date] )

Power Query date built-ins.

[augustindelaf]

the Power Query custom column is much easier !

[astridaku]

thanks so much!!!

it worked

[HarrisMalik]

@astridaku If the solution is working for you please mark it as Answered in order to help other community members.