Forum Discussion

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

DAX Average

Hi    I have a table containing the following columns Property Ref, Build Age, Property Type and Repairs Spend.     Property Ref Build Age Property Type Repairs Spend 39 1919-1944 On...
Need Help
  • DataInsights's avatar
    DataInsights
    5 years ago

    cottrera,

     

    Try this measure:

     

    Average Repairs Spend = AVERAGE ( Table1[Repairs Spend] )

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
5 years ago

cottrera,

 

Try this measure:

 

Average Repairs Spend = AVERAGE ( Table1[Repairs Spend] )