Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Here is a list of my data, essentially what I want to calculate is: (Count x average income)/sum of count by PostCode and/or State if that makes sense.
I've had a play with quick measures etc. but I cant quite get it.
Thanks!
Solved! Go to Solution.
@hughfitz,
Please check if the DAX in the PBIX file below returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok1DJUtrfcCk7XQ48
Regards,
Lydia
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,
Please check if the DAX in the PBIX file below returns your expected result.
https://1drv.ms/u/s!AhsotbnGu1Nok1DJUtrfcCk7XQ48
Regards,
Lydia
Hi Lydia,
thanks a lot for tat, it did return the expected result! Much appreciated :).
Hugh
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |