cancel
Showing results for
Search instead for
Did you mean:
lakshmi9228 Member

## how do I create a column taking columns from different tables using if condition

I have a quantity column from one table,
a dimension column from other table which is grouped by 2 - Bus , other,

Need to create a new column if naming
if quantity > 2, business
if quantity <=2 && group = bus , business
other

Please help me with the solution.
Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
edhans New Contributor

## Re: how do I create a column taking columns from different tables using if condition

I'm not completely clear on what you are asking.  See if this file does what you want

I created a calculated column that I think has the logic you are looking for.

```Category =
VAR TotalQuantity = CALCULATE(SUM('Fact Table'[Quantity]))
RETURN
IF(
TotalQuantity > 2,
"Business",
IF(
TotalQuantity <= 2 && RELATED('Dimension Table'[Group]) = "Business",
"Business",
"Other"
)
)```

If that isn't what you need, please provide some sample data - both tables.

2 REPLIES 2
edhans New Contributor

## Re: how do I create a column taking columns from different tables using if condition

I'm not completely clear on what you are asking.  See if this file does what you want

I created a calculated column that I think has the logic you are looking for.

```Category =
VAR TotalQuantity = CALCULATE(SUM('Fact Table'[Quantity]))
RETURN
IF(
TotalQuantity > 2,
"Business",
IF(
TotalQuantity <= 2 && RELATED('Dimension Table'[Group]) = "Business",
"Business",
"Other"
)
)```

If that isn't what you need, please provide some sample data - both tables.

lakshmi9228 Member

## Re: how do I create a column taking columns from different tables using if condition

Hi edhans,

I was trying the same thing before - due to small syntax problem.
It was not working.

Got where the mistake is from.

Thank you