Add two text columns together?

I have two fields from 2 different projects that contain text. They are the same field and i want to show the results in one column, how do i create a custom measure that adds them together (one of the columns will always be blank).

Hi @markshimmin

Welcome to the Community! :slight_smile:

To combine two different measures, you can use either a Case statement or an IIF statement.
Define a new calculated measure with the following formula:

IIf([Measures].[One project text]="(none)",
[Measures].[Other project text],
[Measures].[One project text])

Replace the names of the measures with your according names. This formula will check if the text from the first project is empty or (none), then it will use text from the other project, but if it is not empty, it will take the text from this first project.

Let me know if this fits your use case or if you have any additional questions on this!
Best regards,
Nauris / eazyBI support