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
1 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
@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
