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.
I have a report built with cases for each item/product line, but in order to get pallet quantity, I need to divide by 40 for JUICE category and 80 for frozen ice. Here's the sample, pallet quantity is incorrect.
Year | Month | billToCustomerNumber | description | GrSalesOrderAmt | Net amount | Pallets | quantity | Prod Line |
2022 | January | REPIR | STR0298 Strawberry FJ 90pk MC-90 cups/ 4oz ea | 4320 | 4104 | 2 | 160 | JUICE |
2022 | January | STAR | CHI0458 Cherrymoji FJ 90pk MC-90 cups/ 4oz ea | 30844 | 30844 | 11 | 880 | JUICE |
2022 | January | STAR | MAN0090 Mango FJ 90pk MC-90 cups/ 4oz ea | 1080 | 1080 | 0.5 | 40 | JUICE |
2022 | January | STAR | STR0298 Strawberry FJ 90pk MC-90 cups/ 4oz ea | 2160 | 2160 | 1 | 80 | JUICE |
2022 | January | STAR | WAT0182 Watermelon FJ 90pk MC-90 cups/ 4oz ea | 1080 | 1080 | 0.5 | 40 | JUICE |
2022 | January | GOR0001 | MAN0020 | 1510 | 1510 | 0.5 | 40 | FrozenIce |
Solved! Go to Solution.
@Ice1341 Hi, here is my possible solution. Hope it helps.
Steps:
1. I have created a conditional column based on the product line.
IF JUICE then 40 else by 80 (So that it give me the right number to divide by qty)
2. Then I simply used the divide function to create a calculated column to get the pallets count.
In case you need to refer to the pbix file, here it is
Could you create a calculated column with your conditions?
@Ice1341 Hi, here is my possible solution. Hope it helps.
Steps:
1. I have created a conditional column based on the product line.
IF JUICE then 40 else by 80 (So that it give me the right number to divide by qty)
2. Then I simply used the divide function to create a calculated column to get the pallets count.
In case you need to refer to the pbix file, here it is
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |