Replace dash symbol with Blank

[prakash11440278]

Hi Power BI Experts,

I want to change the dash symbol to blank in my measure. Can you please help on the dax expression?

Below is the test measure i am using.

MEASURE = IF(SUM(table[sales])<0,"("& SUM(table[sales])&")", SUM(table[sales]))

[harshnathani]

HI @prakash11440278 .

Use ABS function

https://dax.guide/abs/

Regards,

Harsh Nathani

[amitchandak]

@prakash11440278 , refer these blog

https://www.accountingweb.co.uk/business/financial-reporting/power-bi-how-to-bracket-negative-number...

https://www.sumproduct.com/blog/article/power-bi-tips/power-bi-conditionally-formatting-brackets-wit...

[prakash11440278 · Accepted solution]

@harshnathani @amitchandak ,

Thanks for your reply on this issue.

My issue is resolved using Substitute function. Thanks.

Measure: substitute(measure,"-","")