Dynamic Column names not updating

I did manage to get this right, if anyone is interested.

But there is a caviate.

you need to know all the possible options in a slicer.

in my case, it is year-month period slicer. so 12 a year

e.g. for 1 year, the parameter table will have 12 entries calling the same measure, but each line has the specific label for the month.

add another column that links to the period/date table. it needs to be many to many link so date table filters parameter table

bit of a work around but the client is thrilled.

PM me if i can assist.

Ian