Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Most Recent value - help

Hi all,   I have a sheet containing collated invoice requests.   Job number     Invoice Date     Invoice Value     Comments 1001                01/01/2020       £500                  ABC 1002  ...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    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,

ibarrau's avatar
ibarrau
Super User
5 years ago

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,

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This seems to have worked! Thanks so much!