Forum Discussion

Sibrulotte's avatar
Sibrulotte
Helper IV
6 years ago

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 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?

Need Help

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support
    6 years ago

    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's avatar
      Sibrulotte
      Helper IV
      6 years ago

      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's avatar
        v-lid-msft
        Community Support
        6 years ago

        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,