Category Archives: Business intelligence

Callum | Query Parameters in Power Query – Part 2

Posted on 26/08/2016 by Costas Kounadis

As promised, here is Part 2 of Query Parameters in Power Query. My last blog demonstrated how

Πηγή: Callum | Query Parameters in Power Query – Part 2

DAX coding style using variables – SQLBI

Posted on 26/08/2016 by Costas Kounadis

This article shows how variables in DAX can impact the coding style, simplifying a step-by-step approach and improving the readability of your code. The ne

Πηγή: DAX coding style using variables – SQLBI

Grouping in Power Query; Getting The Last Item in Each Group | RADACAD

Posted on 26/08/2016 by Costas Kounadis

Πηγή: Grouping in Power Query; Getting The Last Item in Each Group | RADACAD

Free data visualization with Microsoft Power BI: Your step-by-step guide | CIO

Posted on 15/07/2016 by Costas Kounadis

This step-by-step guide, including video, shows you how to analyze a file with more than two million records of U.S. airline flight delays using Microsoft’s free Power BI platform.

Πηγή: Free data visualization with Microsoft Power BI: Your step-by-step guide | CIO

Make Your Numeric Division Faultless in Power Query | RADACAD

Posted on 21/06/2016 by Costas Kounadis

Πηγή: Make Your Numeric Division Faultless in Power Query | RADACAD

Computing New Customers in DAX – SQLBI

Posted on 27/05/2016 by Costas Kounadis

In this article, Alberto Ferrari describes a new efficient way to compute returning customers in DAX thanks to an idea suggested by a student attending an O

Πηγή: Computing New Customers in DAX – SQLBI

Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI

Posted on 17/05/2016 by Costas Kounadis

Two of the new features in the Power BI Desktop April Update are Query Parameters and Power BI Template files. In this blog post, we will take a deeper look at the new capabilities and scenarios that these two features enable in Power BI.

Πηγή: Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI

Power Query Not for BI: Event Date and Time Scheduler – Part 1 | RADACAD

Posted on 17/05/2016 by Costas Kounadis

Πηγή: Power Query Not for BI: Event Date and Time Scheduler – Part 1 | RADACAD

Creating M Functions From Parameterised Queries In Power BI – Chris Webb’s BI Blog

Posted on 17/05/2016 by Costas Kounadis

Query parameters are, in my opinion, one of the most important features added to Power BI recently. The official blog post describing how to use them is great (read it if you haven’t done so alread…

Πηγή: Creating M Functions From Parameterised Queries In Power BI – Chris Webb’s BI Blog

Pass Parameters to SQL Queries – The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog

Posted on 17/05/2016 by Costas Kounadis

One of the questions I get quite frequently is how we can pass parameters to SQL queries, allowing us to make them dynamic. Someone asked a question in the forum on the topic, so that finally inspired me to write … Continue reading →

Πηγή: Pass Parameters to SQL Queries – The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog