Custom Column: Concatenate Text with multiple IF statements

[Anonymous]

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 · Accepted solution]

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.