Forum Discussion

AlBud's avatar
AlBud
Frequent Visitor
4 years ago
Solved

M Query - If Then Else

Hi all,   I'm having trouble with the below in Power Query when creating a new custom coloumn.   if [ATA Final Destination Port] > = [ETA Final Destination Port] then [ATA Final Destination Port]...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, AlBud ;

    You could try it.

    if [ATA Final] = null then List.Average(#"Changed Type"[Port]) else null

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AlBud's avatar
AlBud
Frequent Visitor
4 years ago

Hi Vijay,

 

That lets me create the new coloumn but I get an error now in the column. I'm wondering if this is due to me have errors in the [Port To Store].

 

 

 

Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

You can enclose your formula in a try otherwise block.

= try your_formula otherwise null

  • AlBud's avatar
    AlBud
    Frequent Visitor
    4 years ago

    Hi Vijay,

     

    If I understood what you've suggested (I'm new to M Query) the below is what I've done and the error I get.

    • Vijay_A_Verma's avatar
      Vijay_A_Verma
      Icon for Most Valuable Professional rankMost Valuable Professional
      4 years ago

      You need to bring otherwise null before last bracket.