Forum Discussion

RK91's avatar
RK91
Frequent Visitor
5 years ago
Solved

Previous value based on date

Hi,   I'm struggeling to get the previous value based on the last known price. My goal is to calculate " this months" volume with last known price before that specific month. I've tried several o...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may download my PBI file from here.  See the last field dragged to the measure.  For March, you will see the value as 0.5720 (the last known weighted average price of the previous year).

    Hope this helps.

RK91's avatar
RK91
Frequent Visitor
5 years ago

Ashish_Mathur thanks for reaching out, find the link below.

https://we.tl/t-HNXMw2bRL8

PrevAmount works for the current year but still have issues with last known value from previous year.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

You may download my PBI file from here.  See the last field dragged to the measure.  For March, you will see the value as 0.5720 (the last known weighted average price of the previous year).

Hope this helps.

  • RK91's avatar
    RK91
    Frequent Visitor
    5 years ago

    Hi, Ashish_Mathur 

    Works great, Thanks!

    I'm also looking for the EUR/KG value from the same month as the last know value, I tried the same formula but it returns blanks.. do you have a solution for this as well?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are welcome.  If my previous reply helped, please mark it as Answer.  Download the PBI file from here with the solution of your new request