Max Column in Row of Dates

[forti4040]

Hello All,

I have a table with 6 columns of dates. I'm trying to add another column that calculates the MAX date from those 6 columns. I'm trying to do this in the query editor, not in DAX. I don't think list.max or table.max accomplish what I'm trying to do...but I'm not 100% sure. 

Any help would be appreciated. 

[camargos88]

Hi @forti4040 ,

try this m code:

List.Min({
[Column1],[Column2],[Column3],[Column4],[Column5],[Column6]
})

[forti4040]

@camargos88 ,

Amazing what a difference one little symbol makes!

I had left out the "{" & "}" in my equation...

Thank you for the guidance. I figured this had to be pretty straight forward 🙂

[camargos88]

@forti4040 ,

Nice you got it done!