Forum Discussion

rwong1's avatar
rwong1
Icon for Helper III rankHelper III
4 years ago
Solved

AVERAGE

Hi,   How do I create another table that shows the monthly average of the NFE by month and year?  I then will convert that to a line chart.  Here is the sample data:    
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi rwong1 ,

     

    Sample data:

     

    Here's my solution.

    1.Create a YearMonth column and a sort column. The sort column is used to sort the YearMonth column.

    YearMonth = FORMAT([Date],"YYYY-MMM")
    sort = VALUE(FORMAT([Date],"YYYYMM"))

     

    2.Then you can drag the NFE column directly into the table and get the average.

     

    3.Or you can create a measure.

    Measure = CALCULATE(AVERAGE('Table'[NFE]),ALLEXCEPT('Table','Table'[YearMonth]))

     

    The line chart:

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

rwong1's avatar
rwong1
Icon for Helper III rankHelper III
4 years ago

It still didn't work.  Please advise.

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Icon for Super User rankSuper User
    4 years ago

    Can you provide the pbix?

     

    • rwong1's avatar
      rwong1
      Icon for Helper III rankHelper III
      4 years ago

      Is there any other way to do this besides sharing the file?  It has confidential info in it.  

      • Tutu_in_YYC's avatar
        Tutu_in_YYC
        Icon for Super User rankSuper User
        4 years ago

        See if this helps ( or if this is what you are trying to achieve )