Help needed for Filed parameter

[Askreddy18]

i have matrix visual, where i am showing 2 measures, CurrentYearMonth_Sales, LastYearMonth_Sales.

I have a slicer for YearMonth.  Based on slicer selection, I have to dynamically update the measure names CurrentYearMonth_Sales, LastYearMonth_Sales to  Lastday of the slicer selcected value.

For ex:. if  2022-09 is selected,  show measure names as,   09-30-2022 Sales,  09-30-2021 Sales.
 I set up filed parameters for this and using SELECTEDVALUE function but its not working

[lbendlin · Accepted solution]

Can't have dynamic measure names. You need to prepare all possible names in a reference table and then control column visibility by a measure.