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,

 

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