Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Expression Error IF is Then else

Hello Everybody,    i have a probem in writing an if function with power query.    I have table with "delivery date wish customer" (gepl.Versanddatum) and "delivery date possible" (machbarer Term...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    Please try this instead

     

    if [#"xmr_vk_analyse (2).Machbarer Termin"] = null then Date.WeekOfYear ([#"xmr_vk_analyse (2).gepl. Versanddatum"]) else Date.WeekOfYear ([#"xmr_vk_analyse (2).Machbarer Termin"])

     

    Pat

mahoneypat's avatar
mahoneypat
Microsoft Employee
4 years ago

Please try this instead

 

if [#"xmr_vk_analyse (2).Machbarer Termin"] = null then Date.WeekOfYear ([#"xmr_vk_analyse (2).gepl. Versanddatum"]) else Date.WeekOfYear ([#"xmr_vk_analyse (2).Machbarer Termin"])

 

Pat

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey Mahoneypat, 

 

thanks for your help. It works. 

 

Question: Could you please explain to me why if to use " = null" instead of is? Or did I get it wrong and I have allways to use  "sings" of logical operations as "=;<;>" when I'm writting a IF statement?