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
I currently have 2 Columns [socket_id] and [Current Ratings] and 1 measure which is MAX Power.
I need to create a NEW COLUMN that is MAX Power/[Current Ratings] as below. It all relates back to the [socket_id]
socket_id MAX Power Current Rating NEW COLUMN
550 0.102 20 0.51%
639 0.027 32 0.08%
666 0.691 20 3.46%
667 1.226 32 3.83%
668 0.415 32 1.30%
669 0.135 32 0.42%
670 7.107 32 22.21%
671 13.373 50 26.75%
672 2.379 32 7.43%
673 0.627 16 3.92%
674 7.643 40 19.11%
675 3.801 32 11.88%
676 1.561 32 4.88%
677 0.79 16 4.94%
678 2.344 20 11.72%
679 0.225 20 1.13%
680 8.336 32 26.05%
681 8.059 50 16.12%
682 0.467 50 0.93%
683 0.108 20 0.54%
Solved! Go to Solution.
Hello @PSRai
You should be able to just add the new column like so.
New Column = DIVIDE ( [MAX Power], YourTable[Current Rating] )
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
Hello @PSRai
You should be able to just add the new column like so.
New Column = DIVIDE ( [MAX Power], YourTable[Current Rating] )
If this solves your issues please mark it as the solution. Kudos 👍 are nice too.
unfortunately I get the following message - A single value for column 'Current Rating' in table 'readings_true_energy' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Hi @PSRai
Please use the above formula in a calculated column not measure. it should work.
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 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |