Forum Discussion
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 | One Bed House | £1,013 |
| 139 | 1945-1964 | Three Bed House | £32 |
| 219 | 1965-1982 | Two Bed Flat | £361 |
| 123 | 1919-1944 | Three Bed House | £201 |
| 114 | Pre 1919 | Two Bed House | £1,638 |
| 19 | 1965-1982 | One Bed House | £976 |
| 179 | 1965-1982 | Three Bed House | £1,117 |
| 24 | Post 2002 | Four Bed House | £1,645 |
| 71 | 1919-1944 | Two Bed House | £886 |
| 136 | 1919-1944 | Two Bed House | £1,128 |
| 82 | Post 2002 | Two Bed Flat | £996 |
| 177 | 1983-2002 | Two Bed House | £1,482 |
| 34 | Post 2002 | Three Bed House | £1,262 |
| 60 | 1945-1964 | One Bed Flat | £123 |
| 216 | Post 2002 | One Bed Flat | £100 |
| 190 | Post 2002 | Two Bed House | £200 |
| 47 | 1983-2002 | One Bed Flat | £154 |
| 127 | 1983-2002 | One Bed Flat | £34 |
| 125 | 1983-2002 | Three Bed House | £1,189 |
| 220 | 1983-2002 | One Bed Flat | £1,090 |
| 210 | 1945-1964 | One Bed Flat | £967 |
| 176 | Post 2002 | One Bed Flat | £128 |
I would ike to summarise in two table visuals the following
Average Repairs Spend by Property Age
Average Repairs Spend by Property Type
Base on the data sample provided I would expect these results
Avg repair spend by build age Build AgeTotal
| 1919-1944 | £807 |
| 1945-1964 | £374 |
| 1965-1982 | £818 |
| 1983-2002 | £790 |
| Post 2002 | £722 |
| Pre 1919 | £1,638 |
and
Avg repairs spend by property type Property TypeTotal
| Four Bed House | £1,645 |
| One Bed Flat | £371 |
| One Bed House | £995 |
| Three Bed House | £760 |
| Two Bed Flat | £679 |
| Two Bed House | £1,067 |
thank you
Richard
