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 m trying to get Max([Weekly Service Sequence]) each TeamId and group them by values like (1,2,3, 4N'more).
i shared an example data and result sample to explain better.
Excel Link : Download Data
Solved! Go to Solution.
@Ewo Please try below steps
For your 1st Question - Create a New Table as below
Test261Out1 = SUMMARIZE(Test261Grouping,Test261Grouping[TeamId],"MaxWeeklyServiceSequence",MAX(Test261Grouping[WeeklyService]))
Then add a New Column to the above table as
SortKey = SWITCH([MaxWeeklyServiceSequence],1,1,2,2,3,3,4)
For 2nd Question - Create a New Table as below which will take the above created table as input.
Test261Out2 = SUMMARIZE(Test261Out1,Test261Out1[GroupName],Test261Out1[SortKey],"TeamCount",COUNTROWS(Test261Out1))
Then select GroupName field and change the "Sort By Column" under Modelling tab to SortKey field
Proud to be a PBI Community Champion
@Ewo Please try below steps
For your 1st Question - Create a New Table as below
Test261Out1 = SUMMARIZE(Test261Grouping,Test261Grouping[TeamId],"MaxWeeklyServiceSequence",MAX(Test261Grouping[WeeklyService]))
Then add a New Column to the above table as
SortKey = SWITCH([MaxWeeklyServiceSequence],1,1,2,2,3,3,4)
For 2nd Question - Create a New Table as below which will take the above created table as input.
Test261Out2 = SUMMARIZE(Test261Out1,Test261Out1[GroupName],Test261Out1[SortKey],"TeamCount",COUNTROWS(Test261Out1))
Then select GroupName field and change the "Sort By Column" under Modelling tab to SortKey field
Proud to be a PBI Community Champion
Thanks alot @PattemManohar ,
First Summarization and Switch function solved the problem 🙂
I made some changes on it and worked.
Thank you again for showing path.
Best,
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |