Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    4 years ago
    if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
CNENFRNL's avatar
CNENFRNL
Community Champion
4 years ago
if [Date Closed] is null and [Critical Defect] = 0 then 1 else 0
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thankyou so much but why = was not working and please adivse the if formula for date Column.thanks