Convert million to billion

[Satya_04]

I have a column where Units can be in billions or millions. If it is in millions, then it needs to be converted into billion.

Can you please guide me?

I am currently getting error "Expressions that yield variant data-type cannot be used to define calculated columns."

[CNENFRNL]

Refer to the last section of this guide FORMAT - DAX Guide

[Tahreem24]

@Satya_04 Try this measure:

Measure =

VAR Mill_ = CALCULATE(SUM('Table'[Value])*1000, FILTER('Table','Table'[Units]="Millions of U.S. Dollars"))

RETURN IF( MAX('Table'[Units]) = "Billions of U.S. Dollars", SUM('Table'[Value]) , Mill_ )