Forum Discussion
Get max date with conditions by Query
Hi, I have a Calendar table and I am trying to get max date with conditions by Query. How can I get 1/3/2021 (max date & holiday=1)? Calendar table date holiday 1/1/2021 1 1/2/20...
=List.Max(Table.SelectRows(Calendar,each [holiday]=1)[date])
You could also just use Table.Max, which lets you use two parameters, like
=Table.Max(PriorStepOrTableName, {"Date", "Holiday"})
--Nate
=List.Max(Table.SelectRows(Calendar,each [holiday]=1)[date])
wdx223_Daniel
Thank you😊It worked😀