Forum Discussion

coskunfirat's avatar
coskunfirat
Frequent Visitor
6 years ago

Using text in the measure

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,

 

1 Reply

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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