Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have linked the file for the report with two databases, Item variant, and Item Ledger, under the Bushel Conversion link along with a picture link that shows each apple variety totals that are the end result. Each item(apple variety) has a variant code based on the variety of the apple and it's packaging type. I need to take the quanitity from the Item ledger and multiple it by the corrosponding standard weight from the Item Ledger, then divide by 40 to convert the quanitity into bushel units. The standard weight is different depending on what the variety and the packaging it is.
(Everything is in bushels, the far right amounts are the grand totals to use)
Simplify your model please. Based on my experience, you may use FILTER Function and SUMX Function.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |