Forum Discussion
Growing average on a graph?
I have work order age column, that I plot average for on a line graph, which looks like this: If I calculate the average for an entire year, I will get 43.70. How do I add a second line to the ...
Anonymous,
Do you have a calendar table? If not, create a calendar table using DAX below. Then create a relationship using date field of the calendar table and Invoice date of your table.
Calendar=CALENDARAUTO()
Afterwards, create the following measure in your table.
Measure = CALCULATE(SUM(yourtable[Age]),FILTER(ALL('Calendar'[Date]),'Calendar'[Date]<=MAX('Calendar'[Date])))/MONTH(MAX('Calendar'[Date]))
If above DAX doesn't help, please share sample data of your table and post expected result here.
Regards,
Lydia