Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Does anyone know why this formula doesn't work correctly, if I have it right and it works similarly in excel?
I need to validate if 3 columns have "Yes" and if this occurs the process is "Yes", if there is any no it will be "No".
Thank you
Solved! Go to Solution.
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
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~
Hi
Tested and worked fine!!
Correct: Yes or No =
IF(
[CKT Populated?] = "Yes" &&
[PTT Name Populated?] = "Yes" &&
[PTT Ticket Populated?] = "Yes",
"Yes",
"No"
)
Tks a lot
Hello xifeng_L
How are you?
I will use the formula to solve my problem.
Many tks for your support
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")
Hello
Many tks for the feedback.
I'm still not as good with power BI as I am with excel.
Thanks
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |