Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 - ...
Need Help
  • smpa01's avatar
    smpa01
    6 years ago

    Can you please try using after VAR vfiltertable

     

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

    RETURN

    VAR _x

     

smpa01's avatar
smpa01
Community Champion
6 years ago

Can you please try using after VAR vfiltertable

 

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

RETURN

VAR _x

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

Thanks.