cancel
Showing results for
Did you mean:
New Member

## 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 Termin)

Problem is that it could be that the "delivery date possible" is a empty cell because the date is equal to "delivery date wish customer".

Therefore i wrote the following formula with the formula editor from "add customer column"

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

This leads to the error message shon in the picture at the end of this contribution.

What is wrong with this formula?

1 ACCEPTED SOLUTION
Super User

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

2 REPLIES 2
Super User

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

New Member

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?

Announcements

#### Launching new user group features

Learn how to create your own user groups today!