SQL Server Mobile Reports – Free Maps of the Week – Christopher Finlan

Hi all – hopefully, you’re as excited as I am about the upcoming GA of SQL Server 2016 on June 1 and with it, the brand new version of Reporting Services.  We’re finishing up the official release o…

Πηγή: SQL Server Mobile Reports – Free Maps of the Week – Christopher Finlan

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

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

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

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

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

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

Trending and Smoothing at PASS BA Conference 2016 – PowerPivotPro

Level: Intermediate Last week I attended the 2016 PASS Business Analytics Conference in San Jose.  I attended my first BA Conference last year and had a blast – this year was equally as good.   However I had a really interesting…

Πηγή: Trending and Smoothing at PASS BA Conference 2016 – PowerPivotPro