Notifications
Clear all
Power BI
4
Posts
2
Users
0
Reactions
64
Views
Topic starter
Hi
I can use the following measure to display the current month
CurrentMonth = Format(TODAY()+1, "MMMM")
but how do I display next Month?
Best Regards
Mo
Posted : 02/11/2019 2:21 pm
Hi Mo,
if this is in a calculated column based on the Date column of Table1, then:
=DATE(YEAR(Table1[Date]),MONTH(Table1[Date])+1,DAY(Table1[Date]))
If you want it in a measure based on today's date, then:
=FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()),"MMMM")
Mynda
Posted : 02/11/2019 10:55 pm
Topic starter
Thanks Mynda
The measure I require is based on today's date.
I tried the code you suggested but I get the following error.
Mohinder
Posted : 05/11/2019 5:55 am
Sorry, missing parenthesis after DAY:
=FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())),"MMMM")
Posted : 05/11/2019 6:01 am
