topic Re: Embedded If Statement with Concatenate in DAX Commands and Tips

Embedded If Statement with Concatenate

WendyMcEwen — Wed, 07 Apr 2021 19:09:01 GMT

I'm trying to create an embedded if statement which combines a letter ("M" or "N") with a field. I'm getting an error with "If". I also tried it in conditional columns. Any ideas? Thank you

If ([Home College] = "MVC" ,
Concatenate ("M", [RecentRCCDCode]),
If [RecentRCCDCode] = "NC" , Concatenate ("N", [RecentRCCDCode]),
[RecentRCCDCode])

Re: Embedded If Statement with Concatenate

Anonymous — Wed, 07 Apr 2021 21:51:29 GMT

WendyMcEwen

Please first read the following rules on writing correct DAX: Rules for DAX Code Formatting - SQLBI. The DAX as written right now is not correct and hence very hard to read.

Is the above formula a formula in a calculated column? Or a measure?