If statement combined with a max date

[Anonymous]

Hi

I'm trying to combine an if statement with a max date. So if a value in a cell in 0 then retrieve the max date from several cells.

I tried the below but got an error as i dont think it like the combination of statements. Is there a way of doing this?

IF Column X = 0 then  List.Max({[#"Column a"]}&{[#"Column b"]}&{[#"column c"]}) else null

Thanks

[jennratten]

@Anonymous Please review the solution and click Accept as Solution if this answered your question.  Thanks!

[jennratten · Accepted solution]

Please try this instead... 

each if [Column X] = 0 then List.Max({[Column A], [Column B],[Column C]}) else null