Current Month - DAX

[Anonymous]

I have a table with 3 years of Data and am writing a dax to get the Current month but somehow it's looking at the past current month as well. What's wrong?

= if Date.MonthName( DateTime.LocalNow() ) = Date.MonthName([Date]) then "Current Month" else Date.MonthName([Date])

How can I exclude past year/past month

[mahoneypat · Accepted solution]

You can adapt your code like this

= if Date.MonthName( DateTime.LocalNow() ) = Date.MonthName([Date]) and Date.Year( DateTime.LocalNow() ) = Date.Year([Date]) then "Current Month" else Date.MonthName([Date])

Pat

[Anonymous]

Thanks, It Worked!