Measure to create average of one column based on latest month from another column

[Jane689]

Hi,

i need to create a measure which will calculate average of column- "visits" from table 'A' only for the latest month from column - "fiscal month" which is also part of table "A" using averagefx or any other function

[tamerj1 · Accepted solution]

Hi @Jane689 

you may try

Measure =
VAR MaxMonth = MAX ( tableA[fiscal month] )

RETURN

AVERAGEX ( 

FILTER ( tableA, tableA[fiscal month] =MaxMonth ),

tableA[visits]
)

[Mikelytics]

Hi @Jane689 

Can you please provide sample data as well as expected outcome as an example?

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.