Formatting Calculated Column

[Anonymous]

Hi Guys,

Please refer the below table:

I've the two columns in my report i.e Usage and Unit and want the third column which will be Unit(Kwh).

I want the uasge values to get multiplied by 1000 where ever unit is mWh and rest should remain same.

I got one part of the expected solution using the below formula but kWh values were missing. Kindly help. me with this.

Unit (Kwh) = IF (

VIEW_FORECASTREVENUE[COMMODITY] = "Electric" && [Unit] in{ "mWh" },

ROUND ( VIEW_FORECASTREVENUE[FORECASTEDUSAGE] * 1000.0, 0 )+0)+0

Regards,

Himanshu

Usage	Unit	Expected Output Column: Unit(kWh)
43450	kWh	43450
2430	mWh	2430000
4500	mWh	4500000
2365	kwh	2365
12345	mWh	12345000

[amitchandak · Accepted solution]

@Anonymous , Try like

Unit (Kwh) = IF (
VIEW_FORECASTREVENUE[COMMODITY] = "Electric" && [Unit] in{ "mWh" },
ROUND ( VIEW_FORECASTREVENUE[FORECASTEDUSAGE] * 1000.0, 0 )+0, VIEW_FORECASTREVENUE[FORECASTEDUSAGE])+0