Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Measure that return current month and current year

‎06-08-2022 05:33 PM

hi all,

 

I would like to have two measure that always return the current month and current year of date. How can I achieve this?

 

Many thanks in advance!

Labels:
Message 1 of 3
304 Views
0
1 ACCEPTED SOLUTION
danextian
Super User
Super User

‎06-08-2022 05:55 PM

Hi @Anonymous 
In addition to @ribisht17's answer, if you want the current month's name, you can use this:

Month Name =
FORMAT ( MONTH ( TODAY () ), "MMMM" )









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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

Message 3 of 3
261 Views
0
2 REPLIES 2
danextian
Super User
Super User

‎06-08-2022 05:55 PM

Hi @Anonymous 
In addition to @ribisht17's answer, if you want the current month's name, you can use this:

Month Name =
FORMAT ( MONTH ( TODAY () ), "MMMM" )









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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Message 3 of 3
262 Views
0
ribisht17
Community Champion
Community Champion

‎06-08-2022 05:41 PM

@Anonymous 

 

MONTH(TODAY())

 

YEAR(TODAY())

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

Message 2 of 3
272 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

View All