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 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
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |