Label expression dynamically

[TomBond77]

Hi experts

For the label expression of a measure I have this line:

'Actuals YTD ' & [Date.Month]={$(=Max([Date.Month])}

I need to show the Month 'MMM' in the label if user is selecting e.g. 4 month: Jan, Feb, Mar, Apr. It should show 'Apr'.

any ideas?

Thanks, tom

[tresesco]

Try using date field instead, like:

'Actuals YTD ' &  Date(Max(yourDateField), 'MMM')

[TomBond77]

not working, it is giving me Jan....independently of Month selection.

[TomBond77]

this expression might be the correct direction, but still gives me an error. Any ideas how to fix it? Thank you!

[tresesco · Accepted solution]

No, that is not the correct direction. 😞

You are trying something like set analysis, which you don't need here, nor it is the right way. In my previous post, I asked to use date field, if you don't have one, try exatly (copy paste) like below:

='Actual YTD ' &  Month(Date#(Max([Date.Month]),'M'))