Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to plot the inventory trend amount by month ?

Hi All   My inventory data as per yollow high lighted column :-     i am able to get current stock amount and LYTD. i need to plot my inventory trend.     My PBI file :- https://www.dr...
Need Help
  • themistoklis's avatar
    themistoklis
    6 years ago

    Anonymous 

     

    Probably you are looking for cumulative values:

     

    See fomula below:

    Inventory Trend =
CALCULATE (
    SUM ( INVENTORY[YTD] ),
    FILTER (
        ALL ( INVENTORY ),
        INVENTORY[Posting Date] <= MAX ( INVENTORY[Posting Date] )
            && NOT ( ISBLANK ( ( INVENTORY[GL Code] ) ) )
    )
)
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

Probably you are looking for cumulative values:

 

See fomula below:

Inventory Trend =
CALCULATE (
    SUM ( INVENTORY[YTD] ),
    FILTER (
        ALL ( INVENTORY ),
        INVENTORY[Posting Date] <= MAX ( INVENTORY[Posting Date] )
            && NOT ( ISBLANK ( ( INVENTORY[GL Code] ) ) )
    )
)
Anonymous's avatar
Anonymous
Not applicable
6 years ago

WOW another expert. Thank you sir