cancel
Showing results for
Did you mean:
Helper I

## Get subsequent month name from selected month in calendar

Hello guys!
I have a question for which I haven't found the solution yet. Can you help me?

I have 3 cards on my report screen. When I select any month I would like the first card to show the selected month and the other two the subsequent months from the first card
For the first card I already have the solution, I just drag the month field from the calendar table to the card, but for the others I don't know how to do it.

Example:

If I select JANUARY the first card will show the text JANUARY, the second will show FEBRUARY and the third one MARCH.

Do you know how I can get these values from the calendar filter selection?

Thank you very much in advance

2 ACCEPTED SOLUTIONS
Super User

Hi,

Assuming the slicer has been built from the Calendar Table, write these measures

Selected month = format(max(Calendar[Date]),"mmmm")

Selected month + 1 = format(max(Calendar[Date])+1,"mmmm")

Selected month + 2 = format(edate(min(Calendar[Date]),2),"mmmm")

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

This is a bit hacky, but you can shift by X months like this:

``= FORMAT ( EOMONTH ( DATEVALUE ( [Month Name] & " 2000"), X), "mmmm" )``

For X = 2, DATEVALUE transforms "January 2000" into DATE(2000, 1, 1), shifts it forward 2 months using EOMONTH to DATE(2000,3,31), and formats this as "March" using the custom FORMAT string "mmmm".

8 REPLIES 8
Super User

This is a bit hacky, but you can shift by X months like this:

``= FORMAT ( EOMONTH ( DATEVALUE ( [Month Name] & " 2000"), X), "mmmm" )``

For X = 2, DATEVALUE transforms "January 2000" into DATE(2000, 1, 1), shifts it forward 2 months using EOMONTH to DATE(2000,3,31), and formats this as "March" using the custom FORMAT string "mmmm".

Helper I

Thanks a lot for the help! It worked correctly!

Super User

Hi,

Assuming the slicer has been built from the Calendar Table, write these measures

Selected month = format(max(Calendar[Date]),"mmmm")

Selected month + 1 = format(max(Calendar[Date])+1,"mmmm")

Selected month + 2 = format(edate(min(Calendar[Date]),2),"mmmm")

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper I

Hi,
it just didn't work in the month of December, it should change to January, but it kept showing January. For the remaining months it worked correctly.
I ended up using the solution that the other colleague indicated, even so I thank you for his help.

Super User

Ensure that the last date in the Calendar table is a December 31, 2023.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper I

Perfect! Thank you again!

Super User

You are welcome.  Please mark that reply of mine as the Answer in which i shared the 3 measures.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper I

Done!