BI

DAX financial functions: Depreciation calculations

  • Article

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this article, he exposes four functions that are popular in the calculation of depreciation and amortization. Those accustomed to these functions within Excel will find the syntax, uses and operation of the functions familiar within the Power BI environment.

2021-01-19

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

The PowerShell Basics If Statement–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

T-SQL Tuesday Retrospective #013: What the business wants

By

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...

Daily Coping 14 Apr 2021

By

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

Read the latest Blogs

Forums

SSRS Report doesn't refresh data

By christi1711

Hi all, I have SSRS Report that uses SP as a source. I have...

Last day of the previous month - Format MM/DD/YYYY

By SQL Server

I use the below to get Last day of Previous Month, but I want...

How to change schema of all tables, views and stored procedures in MSSQL

By carlton 84646

Hello Community, I trying to use the following sql code to change the Schema...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Sorting in R

See possible answers