Forum Discussion

hansei's avatar
hansei
Icon for Helper V rankHelper V
6 years ago
Solved

Help with Summarize

I'm having trouble understanding summarize and wonder if someone could help me? If I have a table as: NAME1 DATE1 NUM1 harry 1/1/2019 11 harry 3/1/2019 22 harry 2/1/2019 33 sa...
DAX
  • hansei's avatar
    hansei
    6 years ago

    I ended up with this for my DAX:

    T2 = SUMMARIZE( 
    Table, Table[NAME1], 
    "DATE2", LASTDATE( Table[DATE1] ), 
    "NUM2", CALCULATE( FIRSTNONBLANK( Table[NUM1], 1 ), LASTDATE( Table[DATE1] ) )
)

    wherein the temporary table returned from LASTDATE propagated filter to orginal Table and then to CALCULATE

hansei's avatar
hansei
Icon for Helper V rankHelper V
6 years ago

Hello Anonymous ,

 

I'm unsure why, but your solution doesn't seem to filter on LastDate. It aggregates all row entries withe the SUM(). It does the same even when written

filter('Table', 'Table'[NAME1] = currentName1 && 'Table'[DATE1] = [LastDate] )

resulting in e.g. 55 for harry

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi hansei ,

 

That surprises me, since I took your sample data and used it in an empty PBIX: