Forum Discussion
Helper IIIAVERAGE
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.
Helper IIIHi,
It only picked up the last value. It did not do the average. Please advise.
- Tutu_in_YYC
Super User
if you use the function AVERAGE, it will calculate the average. You will also need a Year-Month column to be used in the visual. Create this calculated column in the table:
Year-Date = YEAR([Date]) & "-" & FORMAT([Date], "MM")
[Date] will be replace by the column in your table that has the date.Than plot a line chart or a table using Year-Date and the measure you have created.
