Most Recent value - help

Question

Hi all,&nbsp;I have a sheet containing collated invoice requests.&nbsp;Job number&nbsp; &nbsp; &nbsp;Invoice Date&nbsp; &nbsp; &nbsp;Invoice Value&nbsp; &nbsp; &nbsp;Comments1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/01/2020&nbsp; &nbsp; &nbsp; &nbsp;£500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ABC1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/02/2020&nbsp; &nbsp; &nbsp; &nbsp;£750&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DEF1001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/03/2020&nbsp; &nbsp; &nbsp; &nbsp;£100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GHI1003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/03/2020&nbsp; &nbsp; &nbsp; &nbsp;£500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; JKL1002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/04/2020&nbsp; &nbsp; &nbsp; &nbsp;£250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MNO1004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/05/2020&nbsp; &nbsp; &nbsp; &nbsp;£1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PQR&nbsp;Ultimately I need to get the following:Most Recent Invoice DateValue of Most Recent InvoiceComments of Most Recent Invoice&nbsp;I have the following Measures working:MaxInvoiceDate = MAX(Collated[Invoice Date])&nbsp;MaxInvoiceComments = LOOKUPVALUE (Collated[Comments],Collated[Invoice Date],&nbsp;&nbsp;&nbsp;&nbsp;[MaxInvoiceDate],Collated[Job Number],&nbsp;&nbsp;&nbsp;&nbsp;MAX(Collated[Job Number]),Collated[Comments],&nbsp;&nbsp;&nbsp;&nbsp;MAX ( Collated[Comments] ))&nbsp;What I'm having issues with, is determining the value of the most recent invoice.Can anyone help?&nbsp;&nbsp;

ibarrau · Accepted Answer

Hi. You have to pick an aggregation because there will bemore than one date. First you need a calendar table related with that table. That way you can manage dates easily. You can build a measure like this
Sum of Last date = 
CALCULATE (
    SUM ( 'Table'[Invoice] ),
    LASTDATE ( 'Calendar'[Date] )
)
Hope that helps,

Forum Discussion

Most Recent value - help

2 Replies

Related content

Finding the most recent value

Most Recent Transaction

Recent Value

Most recent MAX value

Find Most Recent Date Relative to another Date Column in Power Query