Forum Discussion

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
5 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
    5 years ago

    Try this:

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

    And you get this:

     

     

cottrera's avatar
cottrera
Icon for Post Prodigy rankPost Prodigy
5 years ago

Hi Paul

 

thank you for your quick reponse it works fine