Forum Discussion

CM_Mills's avatar
CM_Mills
Icon for Helper II rankHelper II
2 years ago
Solved

Latest Date Value Measure

Hi,   Number - Lots = CALCULATE( MAX('Data'[Number - Lots (Original)]), FILTER( ALL('Data'), 'Data'[Date - Trade] = MAX('Data'[Date - Trade]) ) )     I have the measure above thats aim to take t...
  • Alf94's avatar
    Alf94
    2 years ago

    Hi CM_Mills,

     

    Can you try the following measure?

     

     

    Measure =
    VAR _maxDate = MAX( 'Table'[Date] )
    RETURN
        CALCULATE(
            SUM( 'Table'[Value] ),
            'Table'[Date] = _maxDate
        )

     

     

    Here is what I get on my side:

     

     

    If I answered your question, please mark my post as a solution.

     

    Best,

Alf94's avatar
Alf94
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi CM_Mills,

 

Can you try the following measure?

 

 

Measure =
    VAR _maxDate = MAX( 'Table'[Date] )
    RETURN
        CALCULATE(
            SUM( 'Table'[Value] ),
            'Table'[Date] = _maxDate
        )

 

 

Here is what I get on my side:

 

 

If I answered your question, please mark my post as a solution.

 

Best,