Forum Discussion

AlBud's avatar
AlBud
Frequent Visitor
3 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
    3 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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, AlBud ;

I don't quite understand what you mean, can you share the results you want to output?


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
3 years ago

v-yalanwu-msft 

 

The average is a number, how do I add this average number to my [ETA] to get an [ETA] + average = [Projected ATA]?

 

i.e. average 39.25 + 09/09/2022 = 18/10/2022