BI

Creating Time-Intelligence Functions in DAX

  • Article

DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in this series, Andy Brown explains how to write measures using the range of date functions in DAX, and also explains how time-intelligence functions work behind the scenes.

2020-03-06

Using Calendars and Dates in Power BI

  • Article

You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages and average opening and closing balances. In this article, Andy Brown shows how to model various scenarios with calendars and dates, and how to get around some of the issues you may encounter.

2020-01-20

Cracking DAX – the EARLIER and RANKX Functions

  • Article

So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and FILTER, but it’s only when you understand the idiosyncrasies of the EARLIER function that you can claim to have genuinely cracked DAX. This article gives four examples of the use of this peculiar function, in the process explaining why it has such a misleading name. Using the EARLIER function properly all boils down (as is so often the case with DAX) to understanding row and filter context. The article also shows how to use the RANKX function to sort data into your required order.

2019-08-26

Streamlining a Power BI Solution

  • Article

Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time is spent organising the solution, however, it can become cluttered. In this article, Gogula Aryalingam explains how to streamline the solution to keep it organized and efficient.

2019-05-27

Reporting Services Basics: Overview and Installation

  • DatabaseWeekly

SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.

2019-05-22

Blogs

Daily Coping 3 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Lock your Azure SQL Database

By

So you have many databases in Azure, you accidentally deleted one which can happen...

BlitzFileStats custom module available for Inspector V2

By

BlitzFileStats is the latest addition to our custom module collection for reporting on data...

Read the latest Blogs

Forums

Changing Connection Managers with the Configuration Manager

By Thom A

OK, this actually not a question, this is in response to a question I...

SSIS How to split a single string into multiple columns using Derived Column

By sabarishbabu

Hello, In my source Column having comma separated with text qualifier(“), I would need...

Licensing Audit Advice

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Licensing Audit Advice

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers