Forum Discussion
Filterable Average based on previous year values
Hi, I am trying to show a graph with this year vs last year average (straight line for last year) I have managed to get the below measure to show correctly but by using ALL in the measure the pag...
Hi,
Share some data and show the expected result.
The data is split across multiple tables but basically idling gallons summed for the previous year then split over weeks as the years average with this years as the actual week values like in the image below but with the previous years average filterable (ability to filter by specific depots)
Idle
Sorry but I am still unable to understand your question. Someone else who does will help.