Creating an average

Hi sbott ,

Thanks for posting your query in the Microsoft Fabric Community. I would like to suggest another tested approach that works effectively even without a separate date table, especially if you already have a MonthYear field in your main table.

Monthly Average Hours = 
VAR TotalHours = SUM('Table'[Sum of Hours])
VAR VisibleMonths = DISTINCTCOUNT('Table'[MonthYear])
RETURN DIVIDE(TotalHours, VisibleMonths)

FYI:

Thanks for your response sbott .

I've attached a PBIX file for more details. Please review it and let me know your insights.

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.