Forum Discussion
cosminc
Post Partisan
Post PartisanSummarize new table with max year only
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 ( ...
try this revision
newfilteredsource = VAR MaxYear = MAX ( Source[Year] ) RETURN SUMMARIZE (FILTER ( Source, Source[Year] = MaxYear ), Source[Salesmen], Source[Sales], "Year", MaxYear )
Zubair_Muhammad
Community Champion
Community ChampionHi
Could you copy paste some sample data with expected results.
Could you copy paste some sample data with expected results.
cosmincPost Partisan
Post PartisanHi,
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]))
Thanks for your help,
Cosmin