Forum Discussion
Ratio between column values
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 ...
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.