Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have combined ARPU Company and ARPU Company figures in the ARPU Mixed.
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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |