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] )
rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
7 years ago

Hi in Power BI (Pivot ou Power Query) a column only have one type. In some cases if we have numbers and text we always set column type as Text.