Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a SharePoint list with 12 columns, each column representing one calendar month. The columns have a dollar value, or null.
Each row represents a product code, and a year.
How do I sum the row, so that I have one dollar value, per year, per product?
Sure I could group and explicitly code each column name, but maybe there is some magic row sum formula?
From this
Product | Year | F1 | F2 | F3 | F4 | .... | F12 |
X | 2023 | 100 | null | 100 | null | null | |
Y | 2024 | 100 | 100 | 100 | null | 100 |
To this
Product | Year | Total |
X | 2023 | 700 |
Y | 2024 | 900 |
Solved! Go to Solution.
1. select product and year column and unpivot other columns
2. group by
Proud to be a Super User!
1. select product and year column and unpivot other columns
2. group by
Proud to be a Super User!
User | Count |
---|---|
73 | |
69 | |
35 | |
27 | |
26 |
User | Count |
---|---|
96 | |
92 | |
54 | |
45 | |
41 |