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.
Hi All,
I've tried to get the sum of a field vale based on numeric range values like have values as (1,2,3,4,5,6,7,8) in one field and i need sum(1+2+3+4) & sum(5+6+7+8) in seperate column.
Any help is appreciated!
hi, @Anonymous
After my test, you could do these ways to achieve it.
Step1:
In edit queries, select the column then duplicate the column
Step2:
Select the duplicate column then click Transform->Split Column->By delimiter
Step3:
then add two custom columns
Result:
Best Regards,
Lin
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |