Using text in the measure

Hi coskunfirat ,

A quick thing is I don't understand your requirement clearly, as you column names in first formula don't have any refrence in the screenshot of the data attached.

Also, you haven't attached any screenshot for the output required.

I understand so far is you want to CONCATENATE two Text columns in a IF condition. If that's the case, you can use something as follows: (CONCATENATE dax function)

Output = IF(ARPU Company == "-",

                    CONCATENATE(Source Country[value],

                                                                                  CONCATENATE("  ", Source Company[value])

                                            )

                  )

Otherwise, please put a screenshot of the output required.

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati