Forum Discussion
Solved
Beginner question
Hello, I have a dataset with 4 columns showing deliveries to our facility. One for the date , one for the customer, one for quantity and one for unit of measure. The unit of measure can be eit...
Try this calculated column. Add the correct conversion factor for Gaylords and Gallons.
Quantity in Tons = SWITCH ( Table1[Unit of Measure], "Gaylords", Table1[Quantity] * <Gaylord conversion factor>, "Gallons", Table1[Quantity] * <Gallon conversion factor>, Table1[Quantity] )Hi jwint ,
Whether the advice given by DataInsights , has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly.
If not, please point it out.
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Looking forward to your feedback.
Best Regards,
Henry
DataInsights
Super User
Super User
Try this calculated column. Add the correct conversion factor for Gaylords and Gallons.
Quantity in Tons =
SWITCH (
Table1[Unit of Measure],
"Gaylords", Table1[Quantity] * <Gaylord conversion factor>,
"Gallons", Table1[Quantity] * <Gallon conversion factor>,
Table1[Quantity]
)