Forum Discussion

smitpau's avatar
smitpau
Icon for Helper I rankHelper I
5 years ago
Solved

Custom Column - Concatenate numbers using & operation

Hi,   I've tried creating a custom column to concatenate 00 to the end of the number based on a condition.   It seems Power Query doesn't want to do this.   Is there a way to do this?   The s...
Need Help
  • lkalawski's avatar
    lkalawski
    5 years ago

    Hi smitpau 

    Based on what you provided, I conclude that the NC column is numeric.
    For this reason, Power BI shows you the error that you cannot use the & character to connect two numbers.

    In your case, the best solution is to multiply * 100 (instead of adding & and 00).

    Try this:

    Table.AddColumn(#"Added Custom1", "NC v2", each if [CC] = "HO" then [NC] * 100 else [NC])

     

    _______________
    If I helped, please accept the solution and give kudos! 😀

lkalawski's avatar
lkalawski
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi smitpau 

Based on what you provided, I conclude that the NC column is numeric.
For this reason, Power BI shows you the error that you cannot use the & character to connect two numbers.

In your case, the best solution is to multiply * 100 (instead of adding & and 00).

Try this:

Table.AddColumn(#"Added Custom1", "NC v2", each if [CC] = "HO" then [NC] * 100 else [NC])

 

_______________
If I helped, please accept the solution and give kudos! 😀

smitpau's avatar
smitpau
Icon for Helper I rankHelper I
5 years ago

Thanks makes sense (converted it to text in the end)