Get the slected slicer value and use it to get the text from another column for a dynamic header

[Areef]

Hi my scenario is that I have a calendar table in my report per below. I have a report page filter by the Date column (Can only filter 1 date at a time).  Is it possible to create a measure such that when a page filter is used to select a Date it uses the data from the corresponding Year and Month columns shown below to generate text which I can use as a dynamic Report page header?

For e.g. if the Date was filtered to 2019-04 from below the dynamic text generated would be "Report for period ended Apr 2019"

[Areef]

Philip thank you very much for your help.  Keep up the good work you & Mynda continue to do

[PhilipTreacy · Accepted solution]

HI @Areef 

You can do this with a measure and take the values directly from the selected date e.g.

Measure = "Report for period ended " & FORMAT(MONTH(SELECTEDVALUE('Table'[Date])),"mmm") & " " & YEAR(SELECTEDVALUE('Table'[Date]))

Regards

Phil

[Areef]

Slight modification to formula.  What worked was:

Dynamic Header Unconsol = "Report for Period ended - " &format(SELECTEDVALUE('Unconsol Calendar'[Date]),"MMMM YYYY")

When I used your initial formula apparently the MONTH part of your  formula was picking up only January rather than the month I was filtering for.  If not for your formula would have never tried and tested and eventually got through

[Areef]

Thanks again Philip and keep up your great work