Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks in advance for helping.
Solved! Go to Solution.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |