Get the value of a measure of the last x intervals from the current datetime with PowerPivot
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.