Forum Discussion
Custom Column: Concatenate Text with multiple IF statements
Hey everyone
I am at work and I have to put together some custom columns from my data. I only have basic understanding of the PowerBI languages, any help would be appreciated.
Here is my starting point. I have two columns with three states. The third column VALUE_MODEL is the custom column, the desired results are given in the fields. The "-" acts as a delimiter between the values from the two columns.
I would compile like this:
VALUE_MODEL = if [TOPICS] <> "" and [LOCAL_BUTTONS] = "" then [TOPICS], else if [TOPICS] <> "" and [LOCAL_BUTTONS] <> "" then [TOPICS]"-"[LOCAL_BUTTONS], else if [TOPICS] = "" and [LOCAL_BUTTONS] = "" then "", else null
I am running into several errors. The first one is a Token Else expected:
Obviously I haven't fully understood the correct syntax here. Any help for a beginner would be highly appreciated. Thank you very much in advance!
- Anonymous3 years ago
I took my time off after work and sat down to calmly and logically approach the problem and do some reading up on DAX syntax. I found this somewhat elegant solution:
RESULT = IF([ONE]<>"null", IF([TWO]<>"null", CONCATENATE([ONE],CONCATENATE("-",[TWO])), [ONE]), [TWO])If you have any idea how to make this more concise or beautiful, please let me know. I think I got the basic understanding of DAX syntax now.
1 Reply
- AnonymousNot applicable
I took my time off after work and sat down to calmly and logically approach the problem and do some reading up on DAX syntax. I found this somewhat elegant solution:
RESULT = IF([ONE]<>"null", IF([TWO]<>"null", CONCATENATE([ONE],CONCATENATE("-",[TWO])), [ONE]), [TWO])If you have any idea how to make this more concise or beautiful, please let me know. I think I got the basic understanding of DAX syntax now.