Sum with conditions from more than one table

[JamieH]

I am trying to a calculation where clauses are coming from multiple tables, which I think is the reason why it isn't working.  Does anyone have any ideas as to how to get the following to work?

NewVar =
SUMX (
    'PDU',
    SWITCH (
        TRUE (),
        'Ret'[pc2] = "PL" && 'PDU'[score] > 0 && 'PDU'[CD] < date(2018,08,01), 'PDU'[sc]*1.1,
        'Ret'[pc2] = "PL" && 'PDU'[score] > 0 && 'PDU'[CD] >= date(2018,08,01), 'PDU'[sc]*1.2,
        'Ret'[pc2] = "PL" && 'PDU'[score] > 0 && 'PDU'[CD] >= date(2021,01,13), 'PDU'[sc]*1.5,
	'Ret'[pc2] <> "PL" && 'PDU'[score] > 0 && 'PDU'[CD] < date(2020,12,01), 'PDU'[sc]*1.1,
	'Ret'[pc2] <> "PL" && 'PDU'[score] > 0 && 'PDU'[CD] >= date(2020,12,01), 'PDU'[sc]*1.5
    )
)

[amitchandak]

@JamieH , conditions 2 and 5 not correct. Create a range using <= date and >= date if needed

[JamieH]

Thanks Amit.  I have changed my dates so they dont overlap in any way, but I still get the error message:

A single value for column 'pc2' in table 'Ret' cannot be determined.