locked
First/last value of a window RRS feed

  • Question

  • How can I get the first/last value of a window?
    Wednesday, June 10, 2015 5:39 AM

Answers

  • 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,

    • Marked as answer by Zafar Abbas Monday, June 22, 2015 12:28 AM
    Wednesday, June 10, 2015 8:55 AM

All replies

  • 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,

    • Marked as answer by Zafar Abbas Monday, June 22, 2015 12:28 AM
    Wednesday, June 10, 2015 8:55 AM
  • Do you have a concrete example how you plan on using the last value in the window?
    Monday, June 15, 2015 6:58 PM