Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

Inventory rotation

I want to get the turnover of the inventory of the last 12 months for each month, I already get the rotation but if I already add the column of the month shows me the rotation of the month and not the whole year, in January 2020 I would have to show me the rotation that goes from January 2020 to February 2019, in the iamgen I show the formula that I occupy for the rotations

chrisdelg_0-1617213255114.png

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Syndicate_Admin , Screenshot is too small to get details.

     

    If you need rolling 12-month formula try a measure like this example with date table

     

    Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-12,MONTH))

     

    or

     

    Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1),-12,MONTH))

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      5 years ago

      Thanks for your help, I already put a little bigger picture, it's practically the same as I've done the problem this in that I have a filter that's next

      chrisdelg_0-1617630552873.png

      But the problem if it's in there in the table of the first example I get the rotations of the month and not those of the full year