How to get current month in power bi

Question

I am trying to add some custom columns using Power Bi 

= Table.AddColumn(#"Filtered Rows", "IsCurrentMonth",  if(Date.Month([Timestamp])=Date.Month(NOW())) then "Current Month" else "Other")

but getting an error message

Expression.Error: The name 'NOW' wasn't recognized. Make sure it's spelled correctly. 

How can I get current month? 

Answer 1

Use the following measure:

= Table.AddColumn(#"Filtered Rows", "IsCurrentMonth",  if(Date.Month([Timestamp])=Date.Month(DateTime.LocalNow())) then "Current Month" else "Other")

Want to learn more about Power BI? Check out today: Power BI course