sum ans max date

[madji]

Hi

I am new in PB.

I try to get sum by max date. I use function "calculation" and filter, I want to see there information about sum by max date

Measure = CALCULATE(Sum('Лист1'[Остаток]); FILTER(ALL('Лист1'); 'Лист1'[Дата].[Date] = MAX('Лист1'[Дата].[Date])))

 

Thanks

[v-yuezhe-msft · Accepted solution]

@madji,

Check if the following DAX returns your expected result, if not, please post expected result here.

Measure = CALCULATE(Sum('Лист1'[Остаток]); FILTER(ALL('Лист1'); 'Лист1'[Дата] = MAX('Лист1'[Дата])))

See my example.


Regards,
Lydia

[madji]

but I want to see max value for each string , not total