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 Champion
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_MuhammadHi
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