BI

Introduction to DAX Financial Functions – Part 1

  • Article

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions. In this article, he exposes five functions that are popular in the calculation of loans and other annuities. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

2020-10-22

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

Blogs

Power BI – Hungry Median

By

Introduction Median is a useful statistical function, which first time appeared in SSAS 2016...

Top 10 Must-Ask Questions Before Going to the Cloud

By

After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top...

Markdown Links– Remembering the Basics

By

For some reason, I can never remember how to do markdown links. I know...

Read the latest Blogs

Forums

error while running Replication

By atulyan.aries

Has anyone faced this error Agent message code 20037. The process could not bulk...

Run Azure Automation Runbook Against DB Hosted on an Azure VM

By dan-404057

Hi - has anyone created a PowerShell runbook which connects to a database hosted...

The Compression Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Compression Type

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers