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, measu...
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 )
Zubair_Muhammad
Community Champion
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_MuhammadCommunity Champion
Community Champion
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 )