Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
try this revision
newfilteredsource = VAR MaxYear = MAX ( Source[Year] ) RETURN SUMMARIZE (FILTER ( Source, Source[Year] = MaxYear ), Source[Salesmen], Source[Sales], "Year", MaxYear )
try this revision
newfilteredsource = VAR MaxYear = MAX ( Source[Year] ) RETURN SUMMARIZE (FILTER ( Source, Source[Year] = MaxYear ), Source[Salesmen], Source[Sales], "Year", MaxYear )
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
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
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |