Beginner question

[jwint]

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 either tons, gaylords, or gallons.  I am trying to add a new column where everything is converted to tons using some sort of math function.  So I need the expression to look at the unit of measure in each row, and apply a conversion factor to change it to tons (and rows that are already reported as tons would stay the same).  Any ideas on this?  Thanks much

[DataInsights · Accepted solution]

@jwint,

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]
)

[v-henryk-mstf · Accepted solution]

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 · Accepted solution]

@jwint,

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]
)