Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help wih calculated column.

Hello All, I am facing this issue when I am using this calculated column:   DAX:  Column = var a = FORMAT(AM,AM[Revenue]) var b = LEFT(a/1000000,4) return CONCATENATE("$",CONCATENATE(b,"...
  • tamerj1's avatar
    tamerj1
    3 years ago

     Oh sorry for that. My intent was to remove the format function completely as it seems there is no indication to impose any specific format. Sorry again I was typing on the phone. 

    DAX: 

    Column = var a = AM[Revenue]
    var b = LEFT(a/1000000,4)
    return
    CONCATENATE("$",CONCATENATE(b,"M"))
     

    Anonymous

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 

please try

DAX: 

Column = var a = FORMAT(AM[Revenue])
var b = LEFT(a/1000000,4)
return
CONCATENATE("$",CONCATENATE(b,"M"))
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    tamerj1 Hi. I tried that.  After the revenue bracket it is showing bracket error as "expected additional parameters"

     

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

       Oh sorry for that. My intent was to remove the format function completely as it seems there is no indication to impose any specific format. Sorry again I was typing on the phone. 

      DAX: 

      Column = var a = AM[Revenue]
      var b = LEFT(a/1000000,4)
      return
      CONCATENATE("$",CONCATENATE(b,"M"))
       

      Anonymous

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        tamerj1 Thank you so much. It Worked. Thanks Again