Title with selected YTD latest Month

[miriammmattar]

Hi,

I have a table of 3 columns: Month, Value and Date

I wanted to create an interactive title using the selected Month from a slicer, so to show a specific Month if only one month is selected or the latest month if multiple months are selected.

I tried the following but the YTD doesn't go to the latest Month, although the column Month is sorted by the date column:

Title = IF(SELECTEDVALUE('table'[Date]), "Sales MTD" & " " & SELECTEDVALUE('Table'[Month]) ,"Sales YTD" & " " & max('Table'[Month]))

Thanks in advance

[ValtteriN]

Hi,

Could you show what your measure is returning? When I tried to re-create the issue I got the desired value without any issues.

Latest month = CONCATENATE(MAX('Calendar'[Month])," YTD")

[miriammmattar]

Thanks @ValtteriN for your reply, if i put date or numbers like u did it comes correct but if i put months short name i get this

[ValtteriN]

Hi,

In that case this might work:
1. Sort your monthname by monthnum:

2. use calendar table instead of Table for the values

3. This DAX worked for me:

Latest month = CONCATENATE(MIN('Calendar'[MonthName])," YTD")

[miriammmattar]

@ValtteriN Just tried that I think the logic goes as per the first alphabet only, I selected Sep, Oct and Nov and yest it showed Nov but if you select as well Jul & Aug it shows Aug insteda of Nov, can you try your end selecting those months as well and let me know if it still works? thanks

[ValtteriN · Accepted solution]

@miriammmattar 

You can force the month with this:

Latest month =

var _rank = CALCULATE(MAX('Calendar'[Month]),ALLSELECTED('Calendar'[MonthName])) return

CONCATENATE(calculate(MAX('Calendar'[MonthName]),ALL('Calendar'),'Calendar'[Month]=_rank)," YTD")

This way it will always return the month whose monthnum is the highest.

[miriammmattar]

@ValtteriN great!!! that worked 🙂