Forum Discussion

coltcarson's avatar
coltcarson
New Member
7 years ago
Solved

Columns With Multiple Data Types

Hello,   Currently within my dataset there is a column that contains both numerical and text data types. Is it possible to convert the numerical data types to currency values while leaving the text...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    coltcarson,

     

    You may add a calculated column as follows.

    Column =
IFERROR ( FORMAT ( CURRENCY ( Table1[Amount] ), "Currency" ), Table1[Amount] )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

coltcarson,

 

You may add a calculated column as follows.

Column =
IFERROR ( FORMAT ( CURRENCY ( Table1[Amount] ), "Currency" ), Table1[Amount] )