Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I want to show the text of a month ie January instead of the number. Here is what I have currently.
Title Page Sub Title text =
Var Year = INT ( YEAR ( TODAY () ) )
Var Quarter = INT ( FORMAT(NOW (),
"q" ) )
Var Month = MONTH (TODAY () )
Return
"1"&" "&Month-2 & " " & " " &"-"&" "&Month-3& "31" " " & Year
It shows 11 instead of November. How do I get it to show November instead? (Also an error message will appear due to the numbers next to month as I want to select the months)
TIA
Solved! Go to Solution.
Please try this approach instead.
Love it, only issue is that it won't let me add -1 after the return so I can change the month.
try this
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |