Forum Discussion
Calculated Column
Hi Guys, Please refer the below table where I have the first 2 columns in my report and the 3rd is the desired column when the Annual Usage is divided by 1000 where ever type name is Electric. ...
Anonymous , Try a measure like
Annual Usage (MWh) = round(CALCULATE(SUM(Deals[AnnualUsage]),FILTER(Deals,Deals[typename]="Electric"))/1000.0,0)
Or new column like
new column = if([typename]="Electric", round([AnnualUsage]/1000.0,0), 0) +0
amitchandak Hi Amit,
Actually 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