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] )
Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago

I don't think that this is currently possible in Power BI. You could always try splitting your data into multiple columns, each with it's own datatype. It appears from your example that every third row is the same datatype. Hope this helps! --Christopher