Dynamic Date Title For Report

[Anonymous]

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?!

[SpartaBI · Accepted solution]

@Anonymous 

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:

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

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. 

[SpartaBI]

@Anonymous 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

[Anonymous]

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

[SpartaBI · Accepted solution]

@Anonymous 

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

Showcase Report – Contoso By SpartaBI

      

[Anonymous]

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]

@Anonymous 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 🙂

[Anonymous]

Were you able to take a look?

[SpartaBI]

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

[Anonymous]

Great thanks!

[SpartaBI · Accepted solution]

@Anonymous 

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:

Showcase Report – Contoso By SpartaBI