Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
drewshu
New Member

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!

 

 Capture.PNG

2 ACCEPTED SOLUTIONS
Zubair_Muhammad
Community Champion
Community Champion

@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 )

 


Regards
Zubair

Please try my custom visuals

View solution in original post

@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 )

Regards
Zubair

Please try my custom visuals

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@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 )

 


Regards
Zubair

Please try my custom visuals

@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 )

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.