Average calculation

Anonymous - 

FTE Avg Measure =
  VAR __Month = MAX('Table'[Month])
RETURN
  AVERAGEX(FILTER(ALL('Table'),[Month]<=__Month),[YTD])

Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 

Please try this expression.

Avg FTE To Date =
VAR thismonth =
    MIN ( 'Calendar'[Month] )
RETURN
    CALCULATE (
        AVERAGEX (
            VALUES ( 'Calendar'[Month] ),
            CALCULATE ( SUM ( 'ActualData'[Actual] ) )
        ),
        ALL ( 'Calendar'[Month] ),
        'Calendar'[Month] <= thismonth
    )

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

Greg_Deckler  mahoneypat  AllisonKennedy Thanks for your replies so far.

It seemed so self explaining for me, but I also have all the background.

I have now created an example.

https://1drv.ms/u/s!AvAYB6UZVhl7tju8Hi2xwXY2Uvai?e=762fNw

Thanks in advance