Forum Discussion
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?!
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
10 Replies
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 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