Forum Discussion

sw123's avatar
sw123
Helper III
1 year ago
Solved

Help with AVERAGEX

Hi,   I am trying to calculate acerage kg per day in Power BI, but can't get it to work. This is the formula I am trying:   Average / day = AVERAGEX(VALUES(Dates[Date]), [KG])   Where Date come...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    Try

    Average / day =
AVERAGEX ( VALUES ( Dates[Date] ), CALCULATE ( SUM ( Production[KG] ) ) )
johnt75's avatar
johnt75
Super User
1 year ago

Try

Average / day =
AVERAGEX ( VALUES ( Dates[Date] ), CALCULATE ( SUM ( Production[KG] ) ) )
sw123's avatar
sw123
Helper III
1 year ago

Thank you, this did the trick.