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
btfergie's avatar
btfergie
Icon for Helper I rankHelper I
5 years ago

Perhaps I shouldn't have used the word smoothing but rather prediction based on surrounding cells.  I am sure there are more and less aggressive ways of doing it.  It would be nice to be able to change the aggressiveness with a filter.

The part I can't figure out is how do I use the surrounding cell values and distances to come up with an estimate of each cell.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

That's the easy part ( and why I mentioned the Game Of Life).  You maintain two separate surfaces.  One for display and one for computation. Once you have computed a new generation you blip it onto the screen.

 

Of course in Power BI you can't do that, it has no memory.  You will need to show the new generation screen (table) next to the old one, and feed it with measures.

 

I'll play with your sample data to see what I can come up with

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

    Yes, I get the idea and I could probably come up with something in Excel.  I am trying to figure it out in Power Query.