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 PartisanThanks!