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...
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

    • PowerBINewbie's avatar
      PowerBINewbie
      New Member
      9 years ago

      Here are the data from 2010 until today.

       

      Temp.xlsx

       

      /PowerBINewbie

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi PowerBINewbie,

         

        You can add a calculate column to get the last instance no, then use summarize function to summary table with "Datum", "ArtNr","Instance", then use the current row value to get the specify value.

         

        Since your instance no is not a numeric type, It is hard to get the max instance no.

         

        Regards,

        Xiaoxin Sheng