Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

MAX VALUE

hi all somebody can help me? A B C D X F 1 20 X G 2 20 Y G BLANK 15 Y G 1 15 Y F 3 15 Y F 4 15   For each value on column A, IF(B="F")&(C isnot "BLANK...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please kindly try this custom column.

    = if  [C]<> null and [B]="F" then List.Max(Table.Column(#"Changed Type","C"))+[D]/2 else [D]/2

     

    List.Max(Table.Column(#"Changed Type","C")) returns the max value of column [C].

    I have no idea about the "Today", if it's a column, just add them in to the formula.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Please kindly try this custom column.

= if  [C]<> null and [B]="F" then List.Max(Table.Column(#"Changed Type","C"))+[D]/2 else [D]/2

 

List.Max(Table.Column(#"Changed Type","C")) returns the max value of column [C].

I have no idea about the "Today", if it's a column, just add them in to the formula.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.