| Date | Sold Units | Ending Inventory | Months on Hand |
| 12/1/2022 | 152 | 355 | 2.4 = 355/average(152,154,136) |
| 11/1/2022 | 154 | 366 | 2.5 = 366/average(154,136,145) |
| 10/1/2022 | 136 | 456 | 3.1 = 456/average(136,145,166) |
| 09/1/2022 | 145 | 458 | 3.0 = 458/average(145,166,145) |
| 08/1/2022 | 166 | 563 | 3.5 = 563/average(166,145,178) |
| 07/1/2022 | 145 | 653 | 3.9 = 653/average(145,178,185) |
| 06/1/2022 | 178 | 523 | 2.8 = 523/average(178,185,195) |
| 05/1/2022 | 185 | 477 | |
| 04/1/2022 | 195 | 386 | |
hi,
I currently have a months on hand dax for the current week, taking the average last 3 months of sales and then dividing my current inventory by it.
I'm looking to expand this view to provide a months on hand calculation for each month. the current dax that I'm using will give the current months on hand as i updated my inventory weekly.
The last column in the sample data is what i'm trying to get to.
I do have an end of month inventory table that I'm planning on using for this. is this possible with in Power Bi?
