Forum Discussion
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,"...
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)returnCONCATENATE("$",CONCATENATE(b,"M"))Anonymous
tamerj1 Hi. I tried that. After the revenue bracket it is showing bracket error as "expected additional parameters"
tamerj1
Community Champion
Community ChampionOh 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 Thank you so much. It Worked. Thanks Again