PowerPivot Time intelligent function and other DAX example

Written by Kasper de Jonge

Wednesday, 21 April 2010 00:58

I was working on a presentation on PowerPivot and decided to share these two quick sample with you, just because i still am amazed by how simple working with DAX is. I am using data from the Contoso database.

First example shows you a time intelligent function sample where i want to see in a chart the daysinstock of this year compared with the days in stock of last year. We start by adding the sum of daysinstock to my chart with Calendaryear and the monthnumber (which is a calculated column in my table monthnumber = MONTH(DimDate[Datekey]) )