Forum Discussion

Omar3000's avatar
Omar3000
Regular Visitor
8 years ago
Solved

Inventory turnover by month

Hello everyone!   I hope anyone can help me with the next issue:   I want to know the inventory turnonver of each product I have by month.   I have the next tables:   MULT, in wich i have the...
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago

    Omar3000

    You can try a measure as

    turn over value =
DIVIDE (
    SUMX (
        FILTER ( ALLSELECTED ( yourTable ), yourTable[date] <= MAX ( yourTable[date] ) ),
        yourTable[value]
    ),
    CALCULATE (
        DISTINCTCOUNT ( yourTable[month] ),
        FILTER ( ALLSELECTED ( yourTable ), yourTable[date] <= MAX ( yourTable[date] ) )
    )
)

    If it is not your case, please post some sample data and expected output.

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Omar3000

You can try a measure as

turn over value =
DIVIDE (
    SUMX (
        FILTER ( ALLSELECTED ( yourTable ), yourTable[date] <= MAX ( yourTable[date] ) ),
        yourTable[value]
    ),
    CALCULATE (
        DISTINCTCOUNT ( yourTable[month] ),
        FILTER ( ALLSELECTED ( yourTable ), yourTable[date] <= MAX ( yourTable[date] ) )
    )
)

If it is not your case, please post some sample data and expected output.