Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lakshmi9228
Helper III
Helper III

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
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

2 REPLIES 2
edhans
Super User
Super User

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.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.