How to Calculate Stock Movements (Slow/ Average/ Fast Moving Stocks)

[Anonymous]

Dear Fellows, I am currently working on an Inventory/Warehouse Management Dashboard and need to calculate stock status from the perspective of Slow Moving Stock, Average/Medium Moving Stock, Fast Moving Stock. Criteria for Stock Movement Categories Slow Moving Stock (Stock that does not move in 12 months), Average/Medium Moving (Stock that Moves within the time frame of 2-12 Months), Fast Moving (Stock that moves every Month) I would really appreciate your help/guidance in how to do that as I am new to DAX programming and know basic calculations in DAX Thanks

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may research the code generated by Quick measure Rolling average.