Forum Discussion
If statement combined with a max date
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 lik...
Please try this instead...
each if [Column X] = 0 then List.Max({[Column A], [Column B],[Column C]}) else null
Please try this instead...
each if [Column X] = 0 then List.Max({[Column A], [Column B],[Column C]}) else null