Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Custom Column Formatting

Hello, 

 

I have a column which is a mixture of numbers and N/A. 

 

Is there a way of formatting the column into thousands using a custom column rather then in the table. I want the N/A to be shown in the table but cannot format the numbers there due to the fact it is a mix of numbers and text. 

 

Any help would be great.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    You can do this as a new column in Power Query:

    and the code for the custom colum is:

    try
Text.From(
Number.FromText([Value]) / 1000) & "k"
otherwise
"N/A"

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous,

    If you replcae "N/A" with null in Query Editor it should allow to format

    Hope this helps
    Mariusz

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    You can do this as a new column in Power Query:

    and the code for the custom colum is:

    try
Text.From(
Number.FromText([Value]) / 1000) & "k"
otherwise
"N/A"