Average the column of a summarized table

[Kit]

Hi all,

Say I've got some data that looks like this in the table called SALES_TABLE.

I'm trying to get a summarized value by month and then find the monthly average. I tried this but it seems I am not allowed to reference the column of a table that is created by the SUMMARIZE function.

What is the way to achieve this?

[Jihwan_Kim · Accepted solution]

Hi,

In the measure, if you created virtual table (temp_table) and wanted to use this virtual table, try writing the measure with averagex, something like below.

averagex(temp_table, [Monthly Sales])

[Kit]

Thanks @Jihwan_Kim! I knew it had to be a simple solution, I just couldn't figure out what it was!