Forum Discussion

sbott's avatar
sbott
Helper I
1 year ago
Solved

Creating an average

Hi, I have a report page that has a number of charts. One of the charts displays the months along the x-axis, with the corresponding number of hours associated with each month represented by a bar. T...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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'.

     

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi sbott ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank You.

  • sbott's avatar
    sbott
    Helper I
    1 year ago

    Apologies, I tried it last week and it didn't come out right, but I have been busy this week so not yet had time to try again.

    • V-yubandi-msft's avatar
      V-yubandi-msft
      Community Support
      1 year ago

      Hello sbott ,

      Thank you for your response, sbott. If possible, please try it and let us know the result. For any future questions or discussions, we encourage you to continue engaging with the community.

       

      — Yugandhar
      Community Support Team.