If Statements that add different columns together.

[Cpman20]

So I'm trying to build a DAX expression to register the binary #s (O,P,Q columns) into specifc text (R column):

I wrote the following code but its giving me an error:

It's saying the expressions that yield variant data-type cannot be used to define calculated columns.

Any insights in how I can fixt this?

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Forecast Status CC =
IF (
    'Analysis 3'[overforecast] = 1,
    "Over forecast",
    IF (
        'Analysis 3'[underforecast] = 1,
        "Under forecast",
        IF ( 'Analysis 3'[on target] = 1, "On target", "0" )
    )
)