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.
I would like to take shipment weights and break them down into weight ranges (ex. 0 - 5, 5 -10, 10-20, etc). I tried the Groups function, but I would have to update that everytime my data was refreshed with new data due to new shipment weights being added. Is there a recommended formula that could be used that would allow the shipment weight to be grouped into these weight ranges i provided earlier and update as my data is refreshed? Thanks.
Hi @cheid1977,
Have you tried the solution provided above? Does it work in your scenario? If the solution works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Thanks for the recommendation. I have had a chance to test it out. As soon as I do I will let you know if it works.
I would just add a calculated column "Weight Bucket". There are a few ways to do this (eg, you could have a separate table that controls the buckets and lookup into it) or whatever, that has the formula (something like)
Bucket = SWITCH( TRUE(),
[Weight] <= 5, "0-5",
[Weight] <= 10, "5-10",
...
[Weight] <= 100, "80-100",
"Real Heavy"
)
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 |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |