Hi Power Bi Community,
I am trying to calcuate the trailing 12 month's average of the monthly average (Beginning Inventory + Ending Inventory / 2). This is to calculate the Inventory Turnover formula (Cost of Goods Sold / Average Inventory). This is always based on the trailing 12 months.
I start with calculating the monthly average:
Monthly Avg =
DATESINPERIOD ( Date_Lookup[Date], LASTDATE ( Date_Lookup[Date] ), -2, MONTH )
) / 2
Then I use the following measure to try and calculate the trailing 12 months average of the monthly averages:
TTM Monthly Avg. =
) / 12
However, that calcuates the applicable monthly average and divides only that month by 12 and does not sum up the trailing 12 monthly averages.
Any help is appreciated.