The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
Solved! Go to 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
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