Forum Discussion

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,"M"))

Please help me correct it. Any help would be much appreciated. Thanks in Advance!

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

4 Replies

tamerj1
Community 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
  Not applicable
  3 years ago
  tamerj1 Hi. I tried that. After the revenue bracket it is showing bracket error as "expected additional parameters"
  - tamerj1
    Community 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