Forum Discussion
Averaging data based on a Date range in a visual
I am looking to create a report on mark up data. To make this report each entry has a start date, an end date, and a markup percentage. I want to create a visual that shows the average markup month...
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.