In this article you will learn how to set up Home Server using IIS and ASP.NET.
Πηγή: A Simple Guide To Setting Up Home Server Using IIS And ASP.NET
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
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
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
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
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
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
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