Sum of Lates Date

[AllanBerces]

Hi,

Thamk you in advance.

Can anyone pls assist me, I have a table below. What measure to write, in need output sum of lates date for a certain date.

Thank you

[v-shex-msft]

HI @AllanBerces,

You can try to use the following measure formula if helps:

formula =
VAR _lastDate =
    CALCULATE ( MAX ( table1[Date] ), ALLSELECTED ( table1 ) )
RETURN
    CALCULATE (
        SUM ( table1[Progress] ),
        FILTER ( ALLSELECTED ( table1 ), [Date] = _lastDate ),
        VALUES ( table1[Team] )
    )

Regards,

Xiaoxin Sheng

[PijushRoy]

Hi @AllanBerces 

Use DATESYTD, find DAX & example
https://learn.microsoft.com/en-us/dax/datesytd-function-dax 

CALCULATE(SUM('TableName'[Progress]), DATESYTD('TableName'[CurrentDate]))  

[AllanBerces]

Thank you for the respond, but on the DAX it calculate the overall progress on that date not on the specific Team on that date. Maybe you can assist me on that. Thank you very much