Get the value of a measure of the last x intervals from the current datetime with PowerPivot

Written by Kasper de Jonge

Saturday, 08 May 2010 00:25

A quick post about a handy dax formula that gives me the sum of a measure of the last x periods using the current time.

The key is using the datesinperiod function in combination with the NOW() function. We can use this function to get a list of all the dates from our fact table that falls in the period defined in the function. You can define a start date and a number of intervals and what intervals to use.