Error formula

I would create the following calculated columns to check each column value by itself.

Check CKT = IF([CKT Populated?] = "Yes", "Yes", "No")
Check PTT Name = IF([PTT Name Populated?] = "Yes", "Yes", "No")
Check PTT Ticket = IF([PTT Ticket Populated?] = "Yes", "Yes", "No")

Hi FelippeAzevedo7 ,

The AND function in DAX supports only two arguments. (https://learn.microsoft.com/en-us/dax/and-function-dax)

So you can change the formula to the following form:

Correct: Yes or No = IF(
    AND(
        AND(
            [CKT Populated?] = "Yes",
            [PTT Name Populated?] = "Yes"
        ),
        [PTT Ticket Populated?] = "Yes"
    ),
    "Yes",
    "No"
)

Or use the logical operators &&:

Correct: Yes or No = 
IF(
    [CKT Populated?] = "Yes" && 
        [PTT Name Populated?] = "Yes" &&
            [PTT Ticket Populated?] = "Yes",
    "Yes",
    "No"
)

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Hello xifeng_L

How are you?

I will use the formula to solve my problem.

Many tks for your support