Forum Discussion
Beginner - 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 MaxWeight
| 1 | 0 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 5 | 3 | 5 |
| 10 | 5 | 10 |
| 15 | 10 | 15 |
| 20 | 15 | 20 |
| 25 | 20 | 25 |
| 30 | 25 | 30 |
| 35 | 30 | 35 |
| 40 | 35 | 40 |
| 45 | 40 | 45 |
| 50 | 45 | 50 |
I wand to add both weight fields to a WB - and then compare where WB on cost is higher than on sales?
2 Replies
DennisSchlein Sorry, what is the expected output you desire? Not quite understanding so maybe an example would help. Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi 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?
