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 tabledateholiday1/1/202111/2/202111/3/202111/4/202101/5/20210 I have try this but those are returning 1/5/2021. = List.Max(Calendar[date], each [holiday]= 1)= List.Max(Calendar[date], each [holiday]= 0) Any help would be greatly appreciated.

=List.Max(Table.SelectRows(Calendar,each [holiday]=1)[date])

Anonymous

Not applicable

3 years ago

Solved

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

I have try this but those are returning 1/5/2021.

= List.Max(Calendar[date], each [holiday]= 1)

= List.Max(Calendar[date], each [holiday]= 0)

Any help would be greatly appreciated.

wdx223_Daniel
3 years ago
=List.Max(Table.SelectRows(Calendar,each [holiday]=1)[date])
Anonymous
3 years ago
You could also just use Table.Max, which lets you use two parameters, like

=Table.Max(PriorStepOrTableName, {"Date", "Holiday"})

--Nate