Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
105 | |
88 | |
75 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |