DAX - Create New Table with variable table

[Anonymous]

I would like to create a sumarize table through a temporary table using only one dax formula.

Example:
Table - Trimestre

DataInicio	DataFim
201911	202001
201912	202002

Table - Sales
PeriodSales

Period	Sales
201910	100
201910	200
201910	300
201911	400
201911	450
201912	460
201912	100
202001	250
202001	260

Summarize Table

I would like to use the table created in the variable "vFilterTable" to calculate de average of [Total] columns by [DataFim] columns directly in this same dax formula. My ideia it was use de function summarizecolumns like below, but it´s not permited. Is there any way to have this summarize result without create another table?

The result that I spect is that:

[amitchandak]

In place of Average([Total]) use AverageX(_vTable,[Total])

[smpa01 · Accepted solution]

Can you please try using after VAR vfiltertable

VAR _x = groupby(vfiltertable,[datafim],"Average", AVERAGEX(CURRENTGROUP(),[total])

RETURN

VAR _x

[Anonymous]

It´s works perfectly.
I didn´t espected that would be so easy. I liked it

Thanks.