Category Archives: Business intelligence

Lost Customers DAX Calculation for Power BI | RADACAD

Posted on 22/11/2016 by Costas Kounadis

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

Pushing Data From Excel To Power BI Using Streaming Datasets – Chris Webb’s BI Blog

Posted on 11/11/2016 by Costas Kounadis

One Power BI feature that almost passed me by (because it was released in August while I was on holiday) was the ability to create streaming datasets in the Power BI web app and push data to them v…

Πηγή: Pushing Data From Excel To Power BI Using Streaming Datasets – Chris Webb’s BI Blog

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 3, List Output

Posted on 23/09/2016 by Costas Kounadis

Power BI Desktop Query Parameters can be used for many use cases. In this post I show you how to use a list output in Power BI Desktop Query Parameters.

Πηγή: Power BI Desktop Query Parameters, Part 3, List Output

Power BI Desktop Parameters, Part2 Dynamic Data Masking (DDM)

Posted on 23/09/2016 by Costas Kounadis

In this post you learn how to implement Dynamic Data Masking (DDM) in SQL Server 2016 and how to user Power BI Desktop Parameters on top of it and much more

Πηγή: Power BI Desktop Parameters, Part2 Dynamic Data Masking (DDM)

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

Create Dynamic Periods for Fiscal or Calendar Dates in Power BI – Gilbert Quevauvilliers – BI blog

Posted on 13/09/2016 by Costas Kounadis

I came across Chris Webb’s excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage t…

Πηγή: Create Dynamic Periods for Fiscal or Calendar Dates in Power BI – Gilbert Quevauvilliers – BI blog

Adding Slicers to a Reporting Services Report – SQLServerCentral

Posted on 26/08/2016 by Costas Kounadis

Πηγή: Adding Slicers to a Reporting Services Report – SQLServerCentral

5 More Power BI Tips | SQL with Dustin Ryan

Posted on 26/08/2016 by Costas Kounadis

I’ve had this blog post in my mind to write for the past month or so and I’m finally just getting around to it while I’m waiting to board my flight back home. Check out my first 5 Power BI Tips her…

Πηγή: 5 More Power BI Tips | SQL with Dustin Ryan