Need help wih calculated column.

[Anonymous]

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]

Hi @Anonymous 

please try

DAX: 

Column = var a = FORMAT(AM[Revenue])

var b = LEFT(a/1000000,4)

return

CONCATENATE("$",CONCATENATE(b,"M"))

[Anonymous]

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

[tamerj1 · Accepted solution]

 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]

@tamerj1 Thank you so much. It Worked. Thanks Again