Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Showing the latest value

Hi All,   I have a table that looks like the following; Date Total Amount Owed 01/01/2020 £1,000.00 01/02/2020 £2,000.00 01/03/2020 £8,000.00 01/04/2020 £6,000.00 01/05/2020...
Need Help
Show and Tell
Tips and Tricks
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

try to create a measure and put it into card visual

Measure = 
var _lastDate = CALCULATE(MAX(Table[Date]))
RETURN
CALCULATE(MAX(Table[Total Amount]), Table[Date] = _lastDate )
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I have entered the following and have received an error message (the sytax is incorrect)

     

    Current WIP =
    var _lastDate = CALCULATE(MAX('Cape Coms'[Date]))
    RETURN
    CALCULATE(MAX('Cape Coms'[Total WIP (£)]), 'Cape Coms'[Date] = LASTDATE)

    Please note the above-mentioned columns are my actual column names.

    Please can you help?
     
     
    • az38's avatar
      az38
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Anonymous 

      of course it is incorrect by syntax, please, pay attention closely to my statement.

      replace your LASTDATE to variable name _lastDate