Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I am trying to divide each subject by "2017 - Total Population" and "2018 - Total Population" and get the percentage.
For example in 2017... 2017 05 Asthma / 2017 - Total Patient Population
For example in 2018... 2018-05 Asthma / 2018- Total Patient Population
2018 - 09 Diabete Mellitus / 2018- Total Patient Population
2018 - 11 Hypertension / 2018 - Total Patient Population
etc...
The problem I can't get over is that they are all in the same column "Subject".
I would keep 2017 in one column and 2018 in another.
Any suggestions would be awesome!!
thanks
Hi @kstudsrud,
Due to I could not reproduce your data structure, could you please offer your data structure and post your desired result if possibel?
Regards,
Daniel He
Each GUID pertains to a specific patinet. I am trying to take the # of rows that say "2017 05 Asthma" and divide it by the # of rows that say "2017- Total Patient Population".
I am trying do do this for all the different measures in the 'Subjuct' column in 2017/2018.
Hi,
Share the link from where i can download your PBI file.
Hi,
Why are they in the same column? Share the source data. Share it in a form that can be pasted in Excel.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |