Forum Discussion

squarecat's avatar
squarecat
Icon for Helper I rankHelper I
1 year ago
Solved

Annual average from monthly average

Hello everyone,  I have a report built on Excel, but management wants it to be migrated to Power BI. In Excel I was using a dynamic table to obtain the sum of all the values per year and per month, ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You can create a measure like

    Avg =
AVERAGEX (
    VALUES ( 'Date'[Year month] ),
    CALCULATE ( SUM ( 'Table'[Amount] ) )
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

You can create a measure like

Avg =
AVERAGEX (
    VALUES ( 'Date'[Year month] ),
    CALCULATE ( SUM ( 'Table'[Amount] ) )
)
squarecat's avatar
squarecat
Icon for Helper I rankHelper I
1 year ago

Thank you! this worked, I just added .[month] for the measure to calculate what I needed, this is my final DAX

Avg =
AVERAGEX (
    VALUES ( 'Calendar'[Date].[Month] ),
    CALCULATE ( SUM ( 'Table'[Amount] ) )
)