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

    Bronze Contributor
    Posted Nov 17, 2019 05:20 AM

    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?


    Renato Loaiza
    Project Manager

    Academy - Online Interactive Learning from Experts