Forum Discussion

PBIUWO's avatar
PBIUWO
Icon for Helper III rankHelper III
6 years ago
Solved

Help creating an average calculation

Hi All,   Currently, I am working on a project to show the daily inventory quantity at the item level and the movement of it compared to the average quantity.  I receive a daily report of the inve...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    6 years ago

    PBIUWO 

     

    You may try the measure below.

    Measure =
AVERAGEX ( VALUES ( 'Table'[Date] ), CALCULATE ( SUM ( 'Table'[Qty] ) ) )

     

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
6 years ago

PBIUWO 

 

You may try the measure below.

Measure =
AVERAGEX ( VALUES ( 'Table'[Date] ), CALCULATE ( SUM ( 'Table'[Qty] ) ) )