March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Instead of averages, how about moving minimums or maximums? The inputs for the calculations are the same as for the moving averages except now its calculating the lowest or highest value over specific time period and then, rolls or "moves" this min-max forward in time. These calculations could also be centered by taking the lowest or highest values from a set of data points located around the middle point of the rolling time period.
You can download the pbix file below. Feel free to poke it.
eyJrIjoiNWFiMDgxNDAtYTZlNy00OGY0LWEyMDQtNDMzNGUzYmUzNDM2IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9