Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.

Inventory Obsolescence Graph

  • 1.  Inventory Obsolescence Graph

    Posted 25 days ago

    Hi All

    I am trying to create an inventory obsolescence month to month trend graph. In my Inventory Warehouse (Syspro ERP) table i have the DateLastStockMove and the inventory value.

    My approach is to calculate <<end of month - date last stock move>>, then with the number of days classify obsolete >365*2, and finally calculate the inventory value for each period of time.

    My issue is that i am not able to create a measure of the <<end of month - date last stock move> because they are in different tables. Now, in the inventory warehouse table i don't have any other date reference.

    Any ideas?

    Thanks



    ------------------------------
    Renato Loaiza
    Project Manager



    renato.loaiza@gmail.comrenato.loaiza@gmail.comrenato.loaiza@gmail.com
    ------------------------------
    Conference-PBI_200x200