Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
i struggle with a new table and i don't know how to put the right syntax
Solved! Go to Solution.
@cosminc Please create a New Table as below
Test293Out = VAR _MaxYear = MAX(Test293Summarize[Year]) RETURN SUMMARIZE(FILTER(Test293Summarize,Test293Summarize[Year]=_MaxYear),Test293Summarize[Salesman],"Sales",SUM(Test293Summarize[Sales]))
Proud to be a PBI Community Champion
@cosminc Please post sample test data and expected output to provide you an accurate solution.
Proud to be a PBI Community Champion
main base
Year | MonthNo | Salesman | Sales |
2019 | 2 | George | 59 |
2019 | 1 | George | 68 |
2018 | 1 | George | 71 |
2018 | 2 | George | 94 |
2018 | 3 | George | 89 |
2018 | 4 | George | 83 |
2018 | 5 | George | 53 |
2018 | 6 | George | 91 |
2018 | 7 | George | 83 |
2018 | 8 | George | 51 |
2018 | 9 | George | 78 |
2018 | 10 | George | 64 |
2018 | 11 | George | 88 |
2018 | 12 | George | 99 |
2017 | 1 | George | 97 |
2017 | 2 | George | 93 |
2017 | 3 | George | 100 |
2017 | 4 | George | 82 |
2017 | 5 | George | 92 |
2017 | 6 | George | 65 |
2017 | 7 | George | 90 |
2017 | 8 | George | 52 |
2017 | 9 | George | 99 |
2017 | 10 | George | 80 |
2017 | 11 | George | 67 |
2017 | 12 | George | 95 |
2019 | 1 | Alex | 59 |
2018 | 1 | Alex | 86 |
2018 | 2 | Alex | 50 |
2018 | 3 | Alex | 65 |
2018 | 4 | Alex | 79 |
2018 | 5 | Alex | 63 |
2018 | 6 | Alex | 94 |
2018 | 7 | Alex | 97 |
2018 | 8 | Alex | 96 |
2018 | 9 | Alex | 98 |
2018 | 10 | Alex | 97 |
2018 | 11 | Alex | 80 |
2018 | 12 | Alex | 92 |
2017 | 1 | Alex | 87 |
2017 | 2 | Alex | 79 |
2017 | 3 | Alex | 57 |
2017 | 4 | Alex | 61 |
2017 | 5 | Alex | 88 |
2017 | 6 | Alex | 77 |
2017 | 7 | Alex | 62 |
2017 | 8 | Alex | 78 |
2017 | 9 | Alex | 60 |
2017 | 10 | Alex | 55 |
2017 | 11 | Alex | 63 |
2017 | 12 | Alex | 57 |
2018 | 2 | Teo | 88 |
2018 | 3 | Teo | 56 |
2018 | 4 | Teo | 85 |
2018 | 5 | Teo | 80 |
2018 | 6 | Teo | 86 |
2018 | 7 | Teo | 73 |
2018 | 8 | Teo | 51 |
2018 | 9 | Teo | 67 |
2019 | 2 | Jenna | 93 |
2019 | 1 | Jenna | 63 |
2018 | 1 | Jenna | 100 |
expected results:
only 2019 and each salesmen only once
Salesmen Sales
George ...
Alex ...
Teo ...
Jenna ...
if has a rank also after sales is a plus, but even without it is fine
further i work with ranks and main base is to bigger; the expression work very hard
so i improvise with a small table
Thanks,
Cosmin
@cosminc Please create a New Table as below
Test293Out = VAR _MaxYear = MAX(Test293Summarize[Year]) RETURN SUMMARIZE(FILTER(Test293Summarize,Test293Summarize[Year]=_MaxYear),Test293Summarize[Salesman],"Sales",SUM(Test293Summarize[Sales]))
Proud to be a PBI Community Champion
Many thanks!
Cosmin
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |