Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
There is an issue with the column I created.
Please refer the below table:
Annual Usage | Typename | Desired Output Column: Annual Usage (MWh) | Unit |
1614892 | Electric | 1615 | kwh |
100000 | Gas | 0 | THM |
175400 | Electric | 175400 | MWh |
2356765 | Gas | 0 | THM |
16877654 | Electric | 16878 | kwh |
I actually want the desired output column for the unit kwh only. I dont want values for "Unit" MWh to change.
What can be done in this scenario?
new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0 : I want a filter where Unit = kwh in my calculation.
I'm basically converting only kwh values to MWh.
Regards,
Himanshu
Solved! Go to Solution.
Hi @Anonymous ,
Can't you create a calculated column as follows:
new column =
IF (
[typename] = "Electric" && [Unit] = "kwh",
ROUND ( [AnnualUsage] / 1000.0, 0 ),
[AnnualUsage]
)
Hi @Anonymous ,
Can't you create a calculated column as follows:
new column =
IF (
[typename] = "Electric" && [Unit] = "kwh",
ROUND ( [AnnualUsage] / 1000.0, 0 ),
[AnnualUsage]
)
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |