DirectQuery workaround

Hello fellow community members,

I followed this very interesting blog post - https://radacad.com/grouping-in-power-query-getting-the-last-item-in-each-group using which I wanted to group my data and retrieve only those rows within a group with a max(integerfield) function, after following the blog it worked perfectly. However, I am unable to use this solution in DirectQuery mode... Would anyone happen to know of a workaround to this?

Appreciate any pointers or feedback.

Thanks!