Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replace Blank with Hyphen in Table

Hi,

 

I just wonder how to replace blank with hyphen in this case below.

 

The values are from a measure therefore I can't use =IF ( ISBLANK(.

Cheers

Jimmy

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    You can do that then data type need to be matched so the number will become text. So you need to take care of formatting using format function in DAX.

     

    IF(isblank([Measure]),"_",[Measure]&"")

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    You can do that then data type need to be matched so the number will become text. So you need to take care of formatting using format function in DAX.

     

    IF(isblank([Measure]),"_",[Measure]&"")

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi,  Anonymous 

     

    Could you please tell me whether your problem has been solved?
    If it is,  please mark the helpful replies or add your reply as Answered to close this thread?

    Best Regards,
    Community Support Team _ Eason