Summarize new table with max year only

[cosminc]

Hi,

i want to make a new table source with only max year data; how can i filter that

i tried this, but doesn't work

newfilteredsource =
VAR MaxYear =
    CALCULATE ( MAX ( Source[Year] ), ALL ( Source ) )
RETURN
    SUMMARIZE (
        Source,
        Source[Salesmen],
        Source[Sales],
        "Year", CALCULATE (
            MAX ( Source[Year] ),
            FILTER ( Source, Source[Year] = MaxYear )
        )
    )

Thanks,

Cosmin

[Zubair_Muhammad · Accepted solution]

@cosminc 

try this revision

newfilteredsource = 
VAR MaxYear = MAX ( Source[Year] )
RETURN
    SUMMARIZE (FILTER ( Source, Source[Year] = MaxYear ),
      Source[Salesmen],
        Source[Sales],
        "Year", MaxYear
        )
    

[cosminc]

Hi

i discovered that it doesn't work proper

there is a difference somewhere

so 2019 sum sales in the new base is different and also part of salesmen have different sum Sales

can you help me please with this?

Thanks,

Cosmin

[Zubair_Muhammad]

Hi
Could you copy paste some sample data with expected results.

[cosminc]

Hi,

i used the answer on another post where i wanted to do unique values for Salesmen and sum of Sales 

Test293Out = 
VAR _MaxYear = MAX(Test293Summarize[Year])
RETURN SUMMARIZE(FILTER(Test293Summarize,Test293Summarize[Year]=_MaxYear),Test293Summarize[Salesman],"Sales",SUM(Test293Summarize[Sales]))

https://community.powerbi.com/t5/Desktop/new-table-summarised-in-a-pivot-but-with-sum/m-p/659951#M31...

Thanks for your help,

Cosmin 

[cosminc]

Thanks!