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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Try this:

 

CALCULATE(LASTNONBLANK(ALL(aterial[MM-YY])

 

If not post sample data so that we can recreate.