Grid smoothing DAX
I am trying to figure out a way to come up with a way to take a 2D XY grid of table values and come up with smoothed values by using the neighboring cells. Perhaps this would use some sort of distance weighted algorithm. I would use this to look for anomolies in the data and replace them with the estimated value if it exceeds a threshold. Thanks.