Forum Discussion
Dynamic Date Title For Report
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: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
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
Hello, how would I make a title card that says January 2022 - the current month and year?
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_monthHello 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/m-p/2564585#M906840
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 🙂