Forum Discussion

btfergie's avatar
btfergie
Icon for Helper I rankHelper I
5 years ago

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 distan...
DAX
estimation
Grid
kernel
smoothing
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Ever played the "Game of Life"?  Of the eight adjacent cells do you assume they all have the same weight, or is the weight of the corner cells less than the edge cells?

btfergie's avatar
btfergie
Icon for Helper I rankHelper I
5 years ago

Yes.  The corners could have a weight of 1/1.41 vs 1 for edge.  I would ideally want to include more distant cells and could have the weight as the inverse of distance.