How do I get a positive sign added to a column

[Anonymous]

I’m trying to add a conditional column that says if the value is greater than 0 (and therefore not negative) then add a + sign infront if the value, but if negative don't 

at the minute it's just adding a column with + and no value after it?

Does anyone have any ideas how to do this so it includes the value?

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Try creating a column as follows:

NewCol = IF([YourColumn] > 0, CONCATENATE("+", [YourColumn]), [YourColumn])

Replace [YourColumn] in above DAX with your actual column from your table.

Thanks,

Pragati

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try this:

newValue = 
FORMAT(
    [yourValuesColumn],
    "+0.0;-0.0;0.0"
)

Pete 

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

You also could change format of the column rather than create a new column.

+#,#.#;-#,#.#;0

Use custom format strings in Power BI Desktop

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try this:

newValue = 
FORMAT(
    [yourValuesColumn],
    "+0.0;-0.0;0.0"
)

Pete 

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Try creating a column as follows:

NewCol = IF([YourColumn] > 0, CONCATENATE("+", [YourColumn]), [YourColumn])

Replace [YourColumn] in above DAX with your actual column from your table.

Thanks,

Pragati

[Fowmy]

@Anonymous 

Try 

 FORMAT([Column],"+0.0")

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Mariusz]

Hi @Anonymous 

Try Measure like this

Measure = 
"+" & SUM( 'Table'[Column1] )

Note, this measure will return text 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn