Forum Discussion
Berl21
Helper III
2 years agoCurrent month in power query
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.
and this last month