Return Most Recent and Second Most Recent Values By Item

[drewshu]

Hello All -- New Power Bi user here and training in the coming weeks. I was tasked with the following but all attempts so far have not worked. I've tried using a combination of Column formulas, measure formulas, and table formulas with no success. Where do I go from here?

I am attempting to return in my report values for the most recent submission as well as the second to last submission by Item. See screenshot. Any help is much appreciated!

 

[Zubair_Muhammad · Accepted solution]

@drewshu

Please try these MEASURES for current date and price

DateCurrent =
MAX ( Table1[Date] )

PriceCurrent =
VAR CurrentDate = [DateCurrent]
RETURN
    CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = CurrentDate )

[Zubair_Muhammad · Accepted solution]

@drewshu

Please try these MEASURES for current date and price

DateCurrent =
MAX ( Table1[Date] )

PriceCurrent =
VAR CurrentDate = [DateCurrent]
RETURN
    CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = CurrentDate )

[Zubair_Muhammad · Accepted solution]

@drewshu

And try these MEASURE for Previousdate and PreviousPrice

DatePrevious =
VAR currentdate = [DateCurrent]
RETURN
    CALCULATE ( MAX ( Table1[Date] ), Table1[Date] < currentdate )

PricePrevious =
VAR PreviouDate = [DatePrevious]
RETURN
    CALCULATE ( SUM ( Table1[Price] ), Table1[Date] = PreviouDate )