Renaming column headers in a table

[Kavitha10]

Hi, I would like to know how to rename column names dynamically in my case scenario.

I have a table with column headers as CY-2,CY-1,CY,CY+1,CY+2 along with many other columns

If CY is 2020, then I need to rename the column names as

when CY is 2021, then they should get renamed as

Please, anyone has an idea ? Thanks in advance.

[amitchandak]

@Kavitha10 , Can you use the year on the column?

Even with this year and YTD , you should be able to use year from date table

[Kavitha10]

Hi , thanks for your response.

I actually have CY-2,CY-1,CY,CY+1,CY+2 as measure values (because the computations changes based on slicer selection). Is it possible to rename the measures dynamically?

[v-xiaotang]

Hi @Kavitha10 

 As far as I know, there's no way to rename the measures dynamically. 

Can you add some more details? So that I might be able to find an alternative method.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.