Forum Discussion

madji's avatar
madji
Helper I
8 years ago
Solved

sum ans max date

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      madji
      Helper I
      8 years ago

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