Forum Discussion
Averaging data based on a Date range in a visual
So do you want an entry that goes from January to June to be weighted in the average of every month from January to June?
yes that is what I am looking for
I don't think there's another way you could do it without creating another table.
The January-June entry would need to somehow have the value of each month from January-June in one sliceable column but idk how that could be done.
But with another table you could easily go:
calculate(average[metric],filter([Start Date]<=[Date] && [End Date]>=[Date]
Would I need to create a table for each month or is there a way to do this in one table with all of the months I need
I'm sorry... My solution would just be a measure for one individual month. If there was a way for your data to be broken down into a row for every entry for every month then you could do it easily. But I'm unsure on how that could happen.