Forum Discussion

cottrera's avatar
cottrera
Post Prodigy
4 years ago
Solved

DAX Average Total

Hi    I have a facts table with the following coliumns - Property Ref, Date & Spend. I also have a calendar tabe with the following Date & Year   Facts Table Property Ref Date Spend 18 ...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try this:

    Aver spend Final =
AVERAGEX ( VALUES ( FactTable[Property Ref] ), DIVIDE ( [Sum spend], 5 ) )

    And you get this:

     

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Try this:

Aver spend Final =
AVERAGEX ( VALUES ( FactTable[Property Ref] ), DIVIDE ( [Sum spend], 5 ) )

And you get this: