First/last value of a window

Question

How can I get the first/last value of a window?

Answer 1

To get the first value you can use the ISFIRST function:

https://msdn.microsoft.com/en-us/library/azure/dn966248.aspx

I think there is no built in function to get the last value at the moment,

Answer 2

Do you have a concrete example how you plan on using the last value in the window?