Percentage based of two counts

[Grimfandango227]

Hello, 

I have two separate counts based on Item Number. 

1 Count is the number of times the Item has been Warrantied  

1 Count is the number of times the Item has shipped. 

I would like to get a rolling 12-month percentage of Items warrantied over Items shipped. 

Please note that Each count comes from a different dataset. 

Is there a measure that could potentially give me what I am looking for?

Any help would be much appreciated. 

Thanks!

Jeremy

[Grimfandango227]

Thanks again @amitchandak !!

[amitchandak · Accepted solution]

@Grimfandango227 , Join the date of your table with the date of the date table and use that in the visual , slicer and measure

12 month rolling

Rolling 12 = CALCULATE(divide( count(Table[Warranties]) , count(Table[Sales Invoice line]) )  ),DATESINPERIOD('Date'[Date],max('Date'[Date]),-12,MONTH))

Rolling Months Formula: https://youtu.be/GS5O4G81fww

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc
https://medium.com/@amitchandak/power-bi-window-function-3d98a5b0e07f