I want to create a measure to find the current average based on YTD data and that the average changes as the months go on. So as it stands I have three months of data Jan 2019 - March 2019 and a small amount of data from April. I only want to have the average of January - March and when April is finished, the numbers from April will be added to the calculation. Then May, June.....and so on. Is it a Rolling average?
Please share sample data of the tables in your model if you want to get an accurate answer. With the little info you provide, I would venture the following measure in a card visual:
VAR _LatestDate =
MAX ( Table1[Date] )
VAR _LatestMonthFinalDay =
EOMONTH ( _LatestDate, 0 )
VAR _LatestDateForCalc =
_LatestDate = _LatestMonthFinalDay,
EOMONTH ( _LatestMonthFinalDay, -1 )
AVERAGE ( Table1[Field_you_want_the_average_on] ),
FILTER ( ALL ( Table1[Date] ), Table1[Date] <= _LatestDateForCalc )
When you get the time, do read through these posting tips (particularly the bits in red). By following them, you will increase the probability of getting your questions answered quickly and you will make things much easier for people trying to help.
I then created another Measure to work out the percentage of completed calls against the forecasted result. This works fine when in a line chart. So far so good. And from this final measure, I want to create an Average.
Looking at your I may need to create a table with Month and Year and then add the values from both tables?