powerbi - Multiple data type column in Power Query - Stack Overflow

admin管理员组

文章数量:1023744

I have a column with multiple data type in Power BI as the following below. How I can convert/modify to Currency ( Fixed decimal number)

old_price

null 990 SR 4,040 SR 50/4 pack SR 445/2 pack null 895 SR 50/4 pack ......

I tried some of ways below

• replace value
• Added Custom column with formular: Convert, Number.From text However, it did not work and get error message

I would like to convert this mixed data into Fixed decimal number

I have a column with multiple data type in Power BI as the following below. How I can convert/modify to Currency ( Fixed decimal number)

old_price

null 990 SR 4,040 SR 50/4 pack SR 445/2 pack null 895 SR 50/4 pack ......

I tried some of ways below

• replace value
• Added Custom column with formular: Convert, Number.From text However, it did not work and get error message

I would like to convert this mixed data into Fixed decimal number

• powerbi
• dax
• data-cleaning
• multiple-databases
• customcolumn

Share Improve this question Follow asked Nov 19, 2024 at 8:44 Tran NhungTran Nhung 311 bronze badge

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Having a mixed type column is generally a very bad idea. You could use something like that:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

    TransformColumn = Table.TransformColumns(
        Source,
        {
            {"Column1", each if Value.Is(_, type number) then Number.ToText(_, "C") else _}
        }
)
in
    TransformColumn

Number.ToText(_, "C") - is used to format string as currency.

I have a column with multiple data type in Power BI as the following below. How I can convert/modify to Currency ( Fixed decimal number)

old_price

null 990 SR 4,040 SR 50/4 pack SR 445/2 pack null 895 SR 50/4 pack ......

I tried some of ways below

• replace value
• Added Custom column with formular: Convert, Number.From text However, it did not work and get error message

I would like to convert this mixed data into Fixed decimal number

I have a column with multiple data type in Power BI as the following below. How I can convert/modify to Currency ( Fixed decimal number)

old_price

null 990 SR 4,040 SR 50/4 pack SR 445/2 pack null 895 SR 50/4 pack ......

I tried some of ways below

• replace value
• Added Custom column with formular: Convert, Number.From text However, it did not work and get error message

I would like to convert this mixed data into Fixed decimal number

• powerbi
• dax
• data-cleaning
• multiple-databases
• customcolumn

Share Improve this question Follow asked Nov 19, 2024 at 8:44 Tran NhungTran Nhung 311 bronze badge

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Having a mixed type column is generally a very bad idea. You could use something like that:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],

    TransformColumn = Table.TransformColumns(
        Source,
        {
            {"Column1", each if Value.Is(_, type number) then Number.ToText(_, "C") else _}
        }
)
in
    TransformColumn

Number.ToText(_, "C") - is used to format string as currency.

本文标签： powerbiMultiple data type column in Power QueryStack Overflow