Keep Values - last day in Month (occured)

[micko90]

Hi 😉 

I have seen some similar problems, but no solution worked for me ;(

I got a table: 

I have multiple time records. I want to keep only values reported on the last day (that occurred) in each month.

In other words, I want to know "Count" regarding ID, Role, and the last occurred day in the month.

I figured it that I need to use "Group By," but probably I am doing something wrong.

I also think that keeping "max" value for every month will work, but I don`t know how to isolate those dates.

Thank you very much, in advance, for your help with this!

[v-yulgu-msft]

Hi @micko90 ,

In posted sample table, there existing only one record per month, what should "last day  in Month" be? Based on such a sample, what is your desired output? Could you show us some examples?

Regards,

Yuliana Gu