Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Please try this instead...
each if [Column X] = 0 then List.Max({[Column A], [Column B],[Column C]}) else null
@Circuscazz Please review the solution and click Accept as Solution if this answered your question. Thanks!
Please try this instead...
each if [Column X] = 0 then List.Max({[Column A], [Column B],[Column C]}) else null