Percentage of Parts Returned By Month

[DakotaGoblinMan]

Hello,

I have two different data sources. One chart is our "usage" for a part, by month for the past 5 years, formated as seen below.

I also have part return data, with a "Assembly Date" which is the same date as when the part is used in the previous table.

Which would consist of the following:

Item No	Assembly Date
AB1	2/2/22
AB1	10/5/20
AB4	5/6/19
Etc.	Etc.

What i am trying to make is a table/graph that would show a part return percentage by month/year such as the following.

Part No.	2019	2020	2021	2022
AB1	5%	10%	15%	20%
AB2	40%	20%	10%	1%
Etc.	1%	1%	1%	1%

What would be the best way to start this? I am fine with just being pointed in the right direction instead of the answer being handed to me. 

Thank you

[changqing]

Hi @DakotaGoblinMan ,

It seems that the first table is not needed in the model? My steps are as follows:

1.  New a carlendar table:

2. Relationship:

3. New a measure:

Measure = 
VAR _count = COUNT('Table'[Item No])
VAR _count_all = CALCULATE(COUNT('Table'[Item No]),ALL('Calendar'))
VAR _result = DIVIDE(_count,_count_all) + 0
RETURN
_result

4. Result:

5. The PBIX file is attached for reference:

Pbix file

Best Regards,
changqing

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I cannot help you without meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive. I cannot use screenshots of your source data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523