Forum Discussion
AND function not working in POwer query
Hello Guys ! I am using this formula in Power query but it showing only else value
if [Date Closed]="null" and [Critical Defect]0 then 1 else 0
if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
3 Replies
Perhaps the contents of the cell is actually null and not a string containing null. Try removing the quote marks around null.
if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
