Forum Discussion

PowerBINewbie's avatar
PowerBINewbie
New Member
9 years ago

Accumulated stockvalue

Hi,   I have summarized a stockvalue for what it was last time the report was refreshed. Now i want to enhance it so i can see the trend over time. I have a log of the movements in the the stock. W...
PowerBINewbie's avatar
PowerBINewbie
New Member
9 years ago

Additional picture of the log:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi PowerBINewbie,

     

    According to your description, I'd like to suggest you use line chart to achieve your requirement.


    Drag Datum column to "Axis" field, Varde to "Value" field. instance to "Legend" field.

     

    Regards,

    Xiaoxin Sheng

     

     

    • PowerBINewbie's avatar
      PowerBINewbie
      New Member
      9 years ago

      Thanks for your answer Xiaoxin Sheng.

       

      Unfortunately this doesnt work because that each part.no. has more than one instance and all instances has a value. So this means that it will sum the value of all instances per part.no up to each date. So the value of the stock is 100times greater than the real value.

       

      Regards,

      PowerBINewbie

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi PowerBINewbie,

         

        If you can please share some sample data to test

         

        Regards,

        Xiaoxin Sheng