Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I currently have date/time column (short date format 11/27/2023). I then have a column to format it to just show as "November 2023" (FORMAT(date, "MMMM YYYY") . Is there a way I can add to the formula to change it to automatically show the prior month so it shows October 2023
Thank you in advance
Solved! Go to Solution.
Hmm. With the DATEADD function, it will only have dates if there is a previous month in your existing date column - from the docs https://learn.microsoft.com/en-us/dax/dateadd-function-dax. So I think the dateadd function might have been the issue.
To get around this, you can try use FORMAT(EOMONTH('calendar'[Date], -1), "MMMM YYYY")
You can use the following formula:
last month formatted =
var lastMonthsDate = DATEADD('calendar'[Date], -1, MONTH)
return FORMAT(lastMonthsDate, "MMMM YYYY")
Thanks @vicky_ . i tried the formula but the end result just comes up with blank values for the column
Hmm. With the DATEADD function, it will only have dates if there is a previous month in your existing date column - from the docs https://learn.microsoft.com/en-us/dax/dateadd-function-dax. So I think the dateadd function might have been the issue.
To get around this, you can try use FORMAT(EOMONTH('calendar'[Date], -1), "MMMM YYYY")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
76 | |
66 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |