Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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?
@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.
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
76 | |
36 | |
22 | |
18 |