Forum Discussion
DennisSchlein
Helper III
Helper IIIBeginner - simple dax (weight and groups)
Hi I have created a table with 3 values. Order id BilledWeightCost BilledWeightSales Weight is a decimal number. What I want to do it adding a weightbreak: WB MinWeight ...
DennisSchleinHelper III
Helper IIIHi Greg_Deckler
Thanks for the advice, ill have that in mind when posting.
I wil try to explain a little better 😛
As example I have a small table:
| Order_id | BilledWeightCost | BilledWeightSales |
| 1 | 1,0 | 1 |
| 2 | 1,7 | 2,4 |
| 3 | 3,8 | 10 |
For both weight columns I want to put them into a weight break that is weight grouped like this:
| WB | MinWeight | MaxWeight |
| 1 | 0 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 5 | 3 | 5 |
| 10 | 5 | 10 |
| 15 | 10 | 15 |
So both billedweightcost and sales should be put into a WB from 2. table where weight is between min and max weight.
And then I want to filter those order where WB from cost is higher than WB from sales.
| Order_id | WB_Sales | WB_Cost |
| 1 | 1 | 1 |
| 2 | 2 | 3 |
| 3 | 5 | 10 |
Does that make sense?