Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    3 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

  • Anonymous's avatar
    Anonymous
    Not 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.