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.
Dear all.
Just trying to transpose from excel to powerbi :).
Lets imagine the following matrix
Columns: A B C D
Rows 1 20 40 60
2 5 10 20
3 1 2 3
I want column D to sum the A B C values. In excel would be = sum (table1[@[A]:[C]). The results should be: row 1 = 120, row 2= 35, row 3 =6
I imported the data from excel. I should execute this formula in my excel table and then import from powerbi or just import the raw data to powerbi and then execute the formula? or its the same?
Eitherway, can you help me with this formula?
Thank you
Hope it gets clear. Thank you
Solved! Go to Solution.
Just create a measure
measure = (sum(col1) + sum(colb)) etc.
Proud to be a Super User!
Just create a measure
measure = (sum(col1) + sum(colb)) etc.
Proud to be a Super User!
It seems im a beginner on this...
Oh...wait...
Thank you
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |