Forum Discussion
Conditial column with a List.Max date
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 e...
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,
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 🙂
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,
