Create an if statement in a measure that returns both text and a column field

Hi Anonymous 

What error did you get? It is better to provide some sample data...if it is a measure, you can't call a field directly... 

Hi there Vera

I figured out that I should be doing this in query (which I have made progress with however I still can't get my formula to concatenate data with text.
My formula is fine until I try to concatenate:

if [#"Trunks & Radials (RPE).RPE Plan"]=[#"Loads (Driver Vehicle).Planned_Total_RPE"] then "OK"
else "Check - "&Text.From[#"Trunks & Radials (RPE).RPE Plan"]&" vs "&Text.From[#"Loads (Driver Vehicle).Planned_Total_RPE"]

The "OK" is present where the condition is met but there is an error where the condition is not met:

(If I use text ("OK" and "Not OK") for both then it works, however I need to concatenate data to create information for the viewer.)

The error message states:

Expression.Error: We cannot apply field access to the type Function.
Details:
Value=[Function]
Key=Trunks & Radials (RPE).RPE Plan

Thanks for your help and patience in advance.

You don't need all the parentheses. Just try this:

Measure = if [Field1] = 0 then "OK" else "Error -"& [Field2]

--Nate

Hi Nate
I tried your suggestion with a test using the following:
if [Field1] = "OK" then "OK" else "Error -"& ([Field2])

Field1 is a calculation returning text "OK"

Field2 is a numerical value

This still has an orange "error" where the condition is not met with the Expression error:

Expression.Error: We cannot apply operator & to types Text and Number.

So then I tried to concatenate like so:

if [Field1] = "OK" then "OK" else "Error -"&Number.ToText([Field2])

Now I get "Error -1" but it isn't yellow and does not link to an explanation.

Any ideas?