Costas Kounadis

Power BI Developer Blog keeps you informed of updates to the Power BI Developer REST APIs, SDKs, and shares examples from the developer community that is building solutions on top Power BI.

Πηγή: Power BI API Updates Roundup (December 2015) – Power BI Developer Blog – Site Home – MSDN Blogs

Franky’s Notes: PowerBI and Microsoft Azure Consumption

Posted on 27/11/2015 by Costas Kounadis

Πηγή: Franky’s Notes: PowerBI and Microsoft Azure Consumption

SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Journey to SQL Authority with Pinal Dave

Posted on 27/11/2015 by Costas Kounadis

Yesterday I had discussed two analytical functions FIRST_VALUE and LAST_VALUE. After reading the blog post I received very interesting question. «Don’t you think there is bug in your first example where FIRST_VALUE is remain same but the LAST_VALUE is changing every line. I think the LAST_VALUE should be the highest value in the windows or…

Πηγή: SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Journey to SQL Authority with Pinal Dave