Year over Year Ratios of Distinct Count

[CoordAnalytics]

Hi, 

I'm new to using Power BI for my organization. We have standard reports we generate every other month that contains a variety of personal information. Each person has a unique ID number. My query pulls in current year -3 for all of the files. I created a Matrix visualization. that displays the data by collection month, then by collection year, then by location. I added a column for a distinct count of the personal ID number. What I need is to add a column that shows the percentage change from year to year. I included an image below, so basically I need to know how to add a colum that would show that from April 2018 to April 2019 there was a 1.14% increase. Hopefully that makes sense. But since this is something we do every other month I'd like to find a way to do it without having to change hard dates in measures. I'm not very familiar with measures in general yet. 

But I also have other pages in my report that look at individual information that's categorical. For example, in the image below you can see the three categories for in April for all three years. Is there a way to see what the percent change is between each year for each category?

Thanks in advance for any guidance anyone can provide. 

[Jihwan_Kim · Accepted solution]

Hi, @CoordAnalytics 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

I created a similar sample pbix file.

All measures are in the file, and all steps are numbered in front of each measure.

https://www.dropbox.com/s/wnw2anbpsltuvd8/coord.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[CoordAnalytics]

This worked great, thank you!