Conditial column with a List.Max date

[Sibrulotte]

How do you obtain the latest date in a series of values, and use that in as a parameter.

For example, I'd want to filter out just the end of month dates, PLUS the latest date of that whole list even if it is not the end of month.

I created a column that has the end of month value, and I'm creating another conditionnal column that tests if these values are the same. But for the latest date that isn't an end of month, I want to know if it's the latest date in my series so I also keep it.

Any super bright ideas for that?

[v-lid-msft]

Hi @Sibrulotte ,

Sorry for that, We cannot understand your data model clearly, Could you please provide a sample mockup table based on fake data or describle the fields of each tables and the relations between tables simply? Please don't have any Confidential Information or Real data in your reply.

Best regards,

[Sibrulotte]

Well I did a work around that is better. I have two cells in excel, and I pass the values in two parameters that are used in a filter in power query.

Solved my problem 🙂

[v-lid-msft]

Hi @Sibrulotte ,

Glad to hear that you have resolved your problem. Thank you for sharing this wonderful solution, would you please kindly mark your sharing solution as an answer so that it can benefit more users?

Best regards,