Using text in the measure

[coskunfirat]

Hello,

I have combined ARPU Company and ARPU Company figures in the ARPU Mixed.

Arpu Mixed = Var Check1 = IF([ARPU BB]="-";[ARPU BB Country];[ARPU BB])

Return Check1

However, I couldn't combine Source Company and Source Country because they are texts.

I would lite to create a formula like this; IF(ARPU Company="-";Source Country[value];Source Company[value])

Regards,

[Pragati11]

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