Forum Discussion

prakash11440278's avatar
prakash11440278
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Replace dash symbol with Blank

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]))

 
 
 

 

Need Help
  • prakash11440278's avatar
    prakash11440278
    5 years ago

    Anonymous amitchandak ,

    Thanks for your reply on this issue.

    My issue is resolved using Substitute function. Thanks.

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

     

3 Replies