Forum Discussion

hughfitz's avatar
hughfitz
Frequent Visitor
8 years ago
Solved

Averages

Hi all,   Real newbie here, I'm using some census data for analysis in power BI and I'm trying to work out the average income of certain postcodes (Australian). It's in a CSV string value format.  ...
Need Help
Tips and Tricks
Tutorial Requests
hughfitz's avatar
hughfitz
Frequent Visitor
8 years ago

To add  to the above, the orignal data was broken down into income ranges ($1-$149, $150-$299 etc.) so I averaged out each to become a single value. i.e. in Queensland, at postcode 4670 there were 343 people earnning $349.50, in addition at the same postcode there were 200 people earning $75, 12 earning $1499 etc. 

Sorry to overexplain, but I havent seen a lot of info on data that is shown in string format on the forum

    • hughfitz's avatar
      hughfitz
      Frequent Visitor
      8 years ago

      Hi Lydia,

      thanks a lot for tat, it did return the expected result! Much appreciated :). 

       

      Hugh