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

sounds like a fun exercise. Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.

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

Below is a dashbboard image.  The tables were too big to add;  I'll have to cut them down somehow.  I was able to do a simple average of immediately adjacent cells but haven't figured out anything more complex.  I would like to be able to do some sort of Inverse Distance Weighting or other interpolation.

In my example, I am replacing values outside and expected range with an average of the 4 or less adjacent cells.

Thanks.

 

 

 

 

 

 

  • 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.