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 )
cosmincPost Partisan
Post PartisanHi
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
Community Champion
Community ChampionHi
Could you copy paste some sample data with expected results.
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]))
Thanks for your help,
Cosmin