Trying to tell powerBI not to include something in a trend calculation

[Candice_Lyons]

Hi there,

I am trying to calculate a trend between two columns of text that I have coded for hierarchical responses. This code works for telling it to not calculate a trend when one of my fields is blank:

TREND_SIGN = IF(NOT(ISBLANK('Threats'[TREND_code])),SIGN(LOOKUPVALUE('Threats'[TREND.CODE in Power BI],'Threats'[SOPParkID],[SOPParkID],
'Threats'[EvaluationPeriod],[EvaluationPeriod]-3-INT(([EvaluationPeriod]-2010)/6),
'Threats'[Response title reporting],[Response title reporting],'Threats'[KeyColumnValue],
[KeyColumnValue],0)-[TREND.CODE in Power BI]))

I now need to add in here another code to tell it if [previous evaluation] = blank, then don't calculate a trend? 

Is this possible? 

[Candice_Lyons]

I should have put a list of what hasn't worked here... Neither of these worked:

1// 

IF(NOT(ISBLANK('Threats'[TREND_code]))
|| NOT ( ISBLANK('Threats'[PREVIOUS_RESPONSE])),SIGN(LOOKUPVALUE('Threats'[TREND.CODE in Power BI],'Threats'[SOPParkID],[SOPParkID],
'Threats'[EvaluationPeriod],[EvaluationPeriod]-3-INT(([EvaluationPeriod]-2010)/6),
'Threats'[Response title reporting],[Response title reporting],'Threats'[KeyColumnValue],
[KeyColumnValue],0)-[TREND.CODE in Power BI]))

2//

TREND_SIGN = IF(NOT(ISBLANK('Threats'[TREND_code]))

&& NOT ( ISBLANK([PREVIOUS_RESPONSE])),SIGN(LOOKUPVALUE('Threats'[TREND.CODE in Power BI],'Threats'[SOPParkID],[SOPParkID],

'Threats'[EvaluationPeriod],[EvaluationPeriod]-3-INT(([EvaluationPeriod]-2010)/6),

'Threats'[Response title reporting],[Response title reporting],'Threats'[KeyColumnValue],

[KeyColumnValue],0)-[TREND.CODE in Power BI]))

[Jihwan_Kim]

Hi, 

I am not sure how your datamodel looks like, but please try using && DAX function or || DAX function.

It represents AND or OR. Please check the link down below.

And, please try the below measure whether it suits your requirement.

And (&&) – DAX Guide

Or (||) – DAX Guide

TREND_SIGN =
IF (
    NOT ( ISBLANK ( 'Threats'[TREND_code] ) )
        && NOT ( ISBLANK ( [previous evaluation] ) ),
    SIGN (
        LOOKUPVALUE (
            'Threats'[TREND.CODE in Power BI],
            'Threats'[SOPParkID], [SOPParkID],
            'Threats'[EvaluationPeriod],
                [EvaluationPeriod] - 3
                    - INT ( ( [EvaluationPeriod] - 2010 ) / 6 ),
            'Threats'[Response title reporting], [Response title reporting],
            'Threats'[KeyColumnValue], [KeyColumnValue],
            0
        ) - [TREND.CODE in Power BI]
    )
)