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

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