Forum Discussion
Solved
Return Most Recent and Second Most Recent Values By Item
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!
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 )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 )
2 Replies
- Zubair_Muhammad
Community Champion
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
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 )