Forum Discussion
DAX - Create New Table with variable table
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 - ...
Can you please try using after VAR vfiltertable
VAR _x = groupby(vfiltertable,[datafim],"Average", AVERAGEX(CURRENTGROUP(),[total])
RETURN
VAR _x
In place of Average([Total]) use AverageX(_vTable,[Total])