Forum Discussion
Solved
Percentage based of two counts
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. ...
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
