Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Using AVERAGEX ON SUMMARIZE DATA

Hi,   I am relatively new to PowerBI and DAX and trying to build a sales report. and would greatly appreciate some help with trying to get an AVERAGEX formula to work.   I am trying to calculate ...
Tips and Tricks
danextian's avatar
danextian
Super User
1 year ago

Hi Anonymous 

 

Try this:

    GROUPBY (
       YourTableExpression,
        "New column name", AVERAGEX ( CURRENTGROUP (), [column to average within the table expression] )