Forum Discussion
btfergie
Helper I
5 years agoGrid 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...
lbendlin
Super User
5 years agoThat should be rather simple, but you won't be able to tune it nicely - you can use a parameter value to twist the knob but it is not nearly as interactive as a slicer. Let's try both ways and compare the outcome.
In Power BI you can use the Play Axis to show multiple generations...
You can calculate the second generation table thusly:
Table2 = SELECTCOLUMNS('Table',"X",'Table'[X],"Y",'Table'[Y],"Generation",2)
Value =
var x = Table2[X]
var y = Table2[Y]
return CALCULATE(max('Table'[Value]),'Table'[X]=x,'Table'[Y]=y) -- plus the weighting of our choice of the neighboring cells)- btfergie5 years ago
Helper I
That looks like it is going to work. Thanks!