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.
Hey guys and gals,
I have a query that contains two columns, [Sales Order Number] (..which is unique) and [Services].
For each Sales Order Number there is a combination of words in Services
111 | Parcel |
112 | Parcel, Parcel |
113 | Parcel, Parcel, Parcel |
114 | Parcel, Parcel, Parcel, Truck |
115 | Parcel, Parcel, Truck |
116 | Parcel, Truck |
117 | Truck |
118 | Truck, Truck |
119 | Truck, Truck,Truck |
121 | Truck, Truck, Parcel |
I need a way to count orders where:
Min. 1 Truck + 1 Parcel = Parcel Split
Min. 2 Truck = Truck Split
Min. 2 Truck + 1 Parcel = Both Parcel Split and Truck Split
And I need a measure that counts all "Truck" and a measure that counts all "Parcel"
Explaination:
I'm trying to do a calculation on the split percentage of orders. So I need to know how many orders where considered a Parcel Split and how many a Truck Split and then divide it by the total amount of orders.
I hope it makes sense and thanks in advance, for the support,
Bassehave
Solved! Go to Solution.
@Bassehave Based on my understanding of the problem , I suggest we should create first these two measures to count the Number of times Parcel occurs in a text column and number of times Truck occurs , below can be used
-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?
@Bassehave Based on my understanding of the problem , I suggest we should create first these two measures to count the Number of times Parcel occurs in a text column and number of times Truck occurs , below can be used
-------------------------------------------------------------------------------------------------------------------------------
Good day, amigo! Have I provided the solution? If so, please let me know by adding the lovely, sweet "solution" tag to my post. And hey, if you're feeling very kind, give me a Kudos; after all, who doesn't enjoy a little digital gratitude?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
70 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
128 | |
29 | |
27 | |
24 | |
22 |