pivot and unpivot with 'value' column.

[PBInonpro]

I have 12 month columns (Jan - Dec) and a finances column (total budget). 

When I unpivot the months columns, i have what I need (column for month and column for value. The problem is that for the measures, the 'finance' column now shows 12x for each line, so the only option is to divide the total finance budget by 12? 

Example:

measure would be 'Finance = sum(finance..)/12 //since there are 12 months and therefor 12x values. 

Finance	Jan	Feb	....	Dec
5000	500	100	....	100
3500	300	200	....	400
1000	400	200	....	0

[v-easonf-msft · Accepted solution]

Hi, @PBInonpro 

Yes. After you unpivot the months columns, you need add a new custom column to divide the total finance budget by 12.

Best Regards,
Community Support Team _ Eason