Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mm_4062
Frequent Visitor

Show current month name

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!
1 ACCEPTED SOLUTION
Jos_Woolley
Solution Sage
Solution Sage

Hi,

Remove the MONTH function, i.e. use:

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

Regards

View solution in original post

2 REPLIES 2
ALLUREAN
Solution Sage
Solution Sage

Hi, @mm_4062 

Try this: 

Current Month Name = FORMAT(TODAY(), "mmmm")



Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




Jos_Woolley
Solution Sage
Solution Sage

Hi,

Remove the MONTH function, i.e. use:

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

Regards

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.