Forum Discussion

sabilahmed's avatar
sabilahmed
Icon for Resolver I rankResolver I
4 years ago
Solved

Multiple arguments in SWITCH formula (&&& not working)

Hi,   I'm positive my DAX is wrong, in particular the && argument (second argument) see below:     How can I fix this? Thanks in advance.
Need Help
  • sabilahmed's avatar
    sabilahmed
    4 years ago

     My bad. I fixed it. I switched the arguments arrounf to put the && one first:

    END_DATE =
    SWITCH (
    TRUE (),
    ('AgreementAdditions & List'[Cancelled Date] = BLANK()) && ('AgreementAdditions & List'[Date End] = BLANK()), 'AgreementAdditions & List'[Today + 3 Years],
    'AgreementAdditions & List'[Cancelled Date] = BLANK(), 'AgreementAdditions & List'[Date End],
    'AgreementAdditions & List'[Cancelled Date] = 'AgreementAdditions & List'[Date End], 'AgreementAdditions & List'[Date End],
    'AgreementAdditions & List'[Cancelled Date]
    )
sabilahmed's avatar
sabilahmed
Icon for Resolver I rankResolver I
4 years ago

 My bad. I fixed it. I switched the arguments arrounf to put the && one first:

END_DATE =
SWITCH (
TRUE (),
('AgreementAdditions & List'[Cancelled Date] = BLANK()) && ('AgreementAdditions & List'[Date End] = BLANK()), 'AgreementAdditions & List'[Today + 3 Years],
'AgreementAdditions & List'[Cancelled Date] = BLANK(), 'AgreementAdditions & List'[Date End],
'AgreementAdditions & List'[Cancelled Date] = 'AgreementAdditions & List'[Date End], 'AgreementAdditions & List'[Date End],
'AgreementAdditions & List'[Cancelled Date]
)