Current month in power query

[Berl21]

Hi,

I want to get a column that automatically says if the month is current or not. So as to make a filter based on it.

I used a function that works really well for years:

if Date.Year(DateTime.LocalNow() )= [Year] then "Current year" else Text.From ([Year])

if Date.Month(DateTime.LocalNow() )= [Month] then "Current month" else Text.From ([Month]) generates an error. 

I suppose the month column has to be formatted in specific way, which might be impacted by the region of the user. Should it be text, then in English? Or in the local language? Or do I have to use a number, then in which format? My tests don't work so far.

Can anyone help me with this?

Thanks,

Pauline.

[Berl21]

@Ahmedx Thank you so much! Seems straightforward once you know the function exists 🙂 You saved my day!

[Ahmedx · Accepted solution]

and this last month

[Ahmedx]

pls try

Int64.From(
Date.IsInCurrentMonth([Business Days]))