Add Column: If statement

[HenryJS]

Hi all,

How can I add a column that returns "Yes" if the following statements are true:

• CSCS is blank
• OR CSCS is in the next 1 Month
• OR Passport is blank
• OR Passportin the next 1 Month
• OR Reference 1 is "No"
• OR Reference 2 is "No"

Please could someone advise the DAX code?

Thank you

[az38 · Accepted solution]

Hi @HenryJS 

try

Column = IF(
ISBLANK([CSCC]) ||
DATEDIFF(TODAY(), [CSCC], MONTH) <= 1 ||
ISBLANK([Passport]) ||
DATEDIFF(TODAY(), [Passport], MONTH) <= 1 ||
[Reference1] = "No" || 
[Reference2] = "No"
,
"Yes",
"Other"
)

[HenryJS]

@az38 yes!! That's perfect. Thank you - can always rely you will give the exact answer as required!!

Hope you are well.

Henry