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 ;

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

    Hi v-yalanwu-msft ,

     

    The result I get should always be a date. As I'm trying to calculate if the [ATA Final] does not have a date, take the average of [Port] and add this to the [ETA].

     

    From what you've sent through, the "nulls" are where I already have a date in the [ATA Final], so this is good! and I can filter this out in the BI report.

     

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