Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a line of business column coming into a sharepoint list and the user can pick multiple requests if the request impacts various lines of businesses. I'd like to be able to get counts of each of the lines of businesses. I've attached a screen shot. After I split the columns into individual columns, how could I get a count of each line of business?
Solved! Go to Solution.
Hello @jcastr02
Once you have split the column into multiple you can unpivot them all to get one long list. Then you can count the number of lines in table for each LOB
@jcastr02
In your case, you can use end brack ")" as the delimiter, in stead of comma.
Paul
Hello @jcastr02
Once you have split the column into multiple you can unpivot them all to get one long list. Then you can count the number of lines in table for each LOB
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |