Forum Discussion
DAX: Average over data gaps
These are just cumulative sums over some measure
calculate(sum[x],filter(all(t[d]),d<max[d]))
Is there a way to fill in these gaps?
2 Replies
Ffitzpatrick47 wrote:
These are just cumulative sums over some measure
calculate(sum[x],filter(all(t[d]),d<max[d]))
Is there a way to fill in these gaps?
What would you like to fill in the gaps? Please post some sample data and expected output.
Maybe the average of the two points so the line will be continuous. Numpy has a nanmean function for example that just takes the average of the two adjacent values to make it smooth. I figured Microsoft bought R, R has a couple functions too that do this too. Does Microsoft?
