Change column name to today's year

[Anonymous]

I have a list of projects with revenues which our users have entered. On this list, they've separated out the revenues into period 1, period 2, period 3 and period 4. Each period represents the year in which the revenue would be landed. Period 1 = Current year. Period 2 = next year...etc.etc.

Does any one know how to dynamically change the period column headers to reflect the year they represent?

I tried to rename the column like such but with no success.

[v-yuta-msft]

Hi martinmcmillz,

Maybe I have understand your requirement. You mean in your table columns like "Period XXX" are quite many, but you want to create some aggregations using these column without inputing these column names, right? I would recommend you to use "Unpivot Columns" to achieve your requreiment. If my understanding is not corrent, please clarify more details about your requriement and expected result.

Regards,

Jimmy Tao

[Anonymous]

Have you tried creating measures?

A measure for each period and it would dinamically display values for each project assuming you have valid relations.

[Anonymous]

Hi Thanks for your quick response.

I haven't. But I'm not entirely sure this will resolve my problem. I can calculated values in each of the years, but if I used measures I'd have to change something in the measure name to make it dynamic to the current year...current year + 1yr...etc.

New measure:

YEAR(TODAY()) = SUM('CRM Data'[Period 1 Revenue])

As I understand DAX, I can't have a dynamic name. Instead I was thinking of dynamically renaming the column.

[Anonymous]

Sorry but you can't dinamically change the column name.

Could you please send a print of the tables (with just a few entries) and the relation diagram?