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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Power5
Helper IV
Helper IV

Dynamic Date Title For Report

Hello, I am wanting to get the last 3 months from the current month for a title for my report. This is what I want it to say but in PowerBI. So now the title should say March 2022 - June 2022. Any ideas?!

Power5_0-1654536304288.png

 

2 ACCEPTED SOLUTIONS
SpartaBI
Community Champion
Community Champion

@Power5 

Create this measure:

 

Title = 
VAR _current_month = FORMAT(TODAY(), "MMMM YYYY")
VAR _3months_before =  FORMAT(EOMONTH(TODAY(), -3), "MMMM YYYY")
RETURN
"First Bank " & UNICHAR(10) & " Monthly Dellinquent Loans Comparison " & _3months_before  & " - " & _current_month

 

 


Then put it in a card visual for example:

View solution in original post

SpartaBI
Community Champion
Community Champion

@Power5 

 

Title = 
VAR _current_month = FORMAT(TODAY(), "MMMM YYYY")
VAR _january_this_year = FORMAT(DATE(YEAR(TODAY()),1,1), "MMMM YYYY")
RETURN
"First Bank " & UNICHAR(10) & " Monthly Dellinquent Loans Comparison " & _january_this_year  & " - " & _current_month

 

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

10 REPLIES 10
Power5
Helper IV
Helper IV

I have a follow up question. How do I get my months to match what I have in my report title. I just want to show the last 3 months from the current month. 

Power5_0-1654542920631.png

 

SpartaBI
Community Champion
Community Champion

@Power5 you can use the date column in the filter pane or a slicer and set it to last 3 calendaric months under the relative date option

Hello, how would I make a title card that says January 2022 - the current month and year?

SpartaBI
Community Champion
Community Champion

@Power5 

 

Title = 
VAR _current_month = FORMAT(TODAY(), "MMMM YYYY")
VAR _january_this_year = FORMAT(DATE(YEAR(TODAY()),1,1), "MMMM YYYY")
RETURN
"First Bank " & UNICHAR(10) & " Monthly Dellinquent Loans Comparison " & _january_this_year  & " - " & _current_month

 

 


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Showcase Report – Contoso By SpartaBI


SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Full-Logo11.png

Hello SpartBI, 

 

By chance could you take a look at this question I had. https://community.powerbi.com/t5/Desktop/How-do-I-transpose-my-data-but-then-also-create-row-headers...

 

SpartaBI
Community Champion
Community Champion

@Power5 sure, it's already night here so we'll take a look at it tomorrow. Tag me tomorrow there to remind me. In case I answered the previous question don't forget to mark it as a solution for community visability. 

P.S. check out my report:

https://community.powerbi.com/t5/Data-Stories-Gallery/Contoso-by-SpartaBI/td-p/2449543.

 

Appreciate your kudos 🙂

Were you able to take a look?

SpartaBI
Community Champion
Community Champion

Hey! No, sorry, why didn't you write to me earlier :)) I will PM you

Great thanks!

SpartaBI
Community Champion
Community Champion

@Power5 

Create this measure:

 

Title = 
VAR _current_month = FORMAT(TODAY(), "MMMM YYYY")
VAR _3months_before =  FORMAT(EOMONTH(TODAY(), -3), "MMMM YYYY")
RETURN
"First Bank " & UNICHAR(10) & " Monthly Dellinquent Loans Comparison " & _3months_before  & " - " & _current_month

 

 


Then put it in a card visual for example:

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.