Error in Power Query in Power BI

[Analitika]

Hello,

I am  getting error in this code 

How to solve this?

[v-kkf-msft · Accepted solution]

Hi @Analitika ,

I see that you are using the same logic for "Komtus" and "i osis verting bluras", then please try

If [Imone] = "Komtus" or [Imone] = "i osis verting bluras" then [Imone] & [zur2] else [zurnalas ir kodas]

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AntonioM]

Starting on the first line, if you remove 'else [zurnalas ir kodas]' then that should work.

You need to always have 

if (condition) then (result) else if (condition 2) then (result 2) else if (condition 3)...

... else (final result)

[Analitika]

My goal to concatenate two columns to one according to conditions. If name="ads" then a & b else a & c else if ..

[AntonioM]

Sure, so there in your example you would need something like 

If name = "ads" then a & b else 
if name = "   " then a & c else 
if ...

You always need IF - THEN - ELSE