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]
    )

1 Reply

  • 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]
    )