Show current month name

Question

I have a card that I would like to display the current month name. I.e. today is 04/07/2022 and I would like it to read July.

I have created the following measure:

Current_month = Month(Now())

Which produces the result: 7

I have adapted the current measure to read as follows:

Current_month = Format(Month(Now()),"MMMM")

Which produces the result: January

I have also tried creating a separate measure to source the first measure (in red):

Current Month Name = FORMAT([Current_month],"MMMM")

Which produces the result: January

I feel like this should be very straightforward but I'm stuggling to find an answer online. Thanks for your help!

jos_woolley · Accepted Answer

Hi,Remove the MONTH function, i.e. use:Current_month = Format(Now(),"MMMM")Regards

Forum Discussion