Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
prakash11440278
Post Prodigy
Post Prodigy

Replace dash symbol with Blank

‎02-19-2021 02:31 AM

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

 
 
 

Capture.PNG

 

Labels:
Message 1 of 4
1,094 Views
0
1 ACCEPTED SOLUTION
prakash11440278
Post Prodigy
Post Prodigy
In response to amitchandak

‎02-19-2021 02:47 AM

@harshnathani @amitchandak ,

Thanks for your reply on this issue.

My issue is resolved using Substitute function. Thanks.

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

 

View solution in original post

Message 3 of 4
1,088 Views
0
3 REPLIES 3
harshnathani
Community Champion
Community Champion

‎02-19-2021 02:42 AM

HI @prakash11440278 .

 

Use ABS function

 

https://dax.guide/abs/

 

Regards,

Harsh Nathani

Message 4 of 4
1,090 Views
0
prakash11440278
Post Prodigy
Post Prodigy
In response to amitchandak

‎02-19-2021 02:47 AM

@harshnathani @amitchandak ,

Thanks for your reply on this issue.

My issue is resolved using Substitute function. Thanks.

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

 

Message 3 of 4
1,089 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All