Tag Archives: Power Query

Lost Customers DAX Calculation for Power BI | RADACAD

Posted on 22/11/2016 by Costas Kounadis

Πηγή: Lost Customers DAX Calculation for Power BI | RADACAD

Analyzing events with a duration in DAX – SQLBI

Posted on 11/11/2016 by Costas Kounadis

This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date

Πηγή: Analyzing events with a duration in DAX – SQLBI

Power BI Desktop Query Parameters, Part 1

Posted on 23/09/2016 by Costas Kounadis

This article shows you how to create dynamic data sources using Power BI query parameters. You also learn how to use query parameters in Filter Rows.

Πηγή: Power BI Desktop Query Parameters, Part 1

Combination of rows of tables list in Power Query – Ivan Bond’s blog

Posted on 23/09/2016 by Costas Kounadis

Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Anal…

Πηγή: Combination of rows of tables list in Power Query – Ivan Bond’s blog

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

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

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

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

Conditional Code Branching in Power BI Query: if…then…else => then…else…if | Avi Singh | LinkedIn

Posted on 17/05/2016 by Costas Kounadis

If…Then…Else in a Custom Column We have all used an “if…then…else” statement, when adding a custom column in Power BI query (using Excel Power Query, or Power BI > Get Data). Here is a quick example

Πηγή: Conditional Code Branching in Power BI Query: if…then…else => then…else…if | Avi Singh | LinkedIn