Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PBInonpro
Helper III
Helper III

pivot and unpivot with 'value' column.

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. 

 

FinanceJanFeb....Dec
5000500100....100
3500300200....400
1000400200....0
1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @PBInonpro 

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

veasonfmsft_0-1671171927893.png

 

Best Regards,
Community Support Team _ Eason

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @PBInonpro 

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

veasonfmsft_0-1671171927893.png

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors