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
Anonymous
Not applicable

Multiple SubGroupings

I want to create a new column tgat has many sub-conditions. Something as follows:

 

if(Text='Apple','Mango', if(Edible='Yes', if(Edible='No'))) as Eatable. However, the variable Text is in one table and Edible is in another table.

 

Can this be done? thank You!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous

 

Yes, you can do that. Use RELATED funtion and also pls make sure the requied relationship is done properly.

New Column = 
IF( Table1[Col1] = "Apple", "Fruit", IF (RELATED(Table2[Edible]))= "Yes", "Eatable","Not Eatable") )

Thanks
Raj

 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous

 

Yes, you can do that. Use RELATED funtion and also pls make sure the requied relationship is done properly.

New Column = 
IF( Table1[Col1] = "Apple", "Fruit", IF (RELATED(Table2[Edible]))= "Yes", "Eatable","Not Eatable") )

Thanks
Raj

 

Anonymous
Not applicable

@Anonymous

 

Hey,

 

I actually have a code as follows in QlikView

 

if(Text='manufacturing', if(dir_indir='Dir', 'DIR', if(dir_indir='Indir', 'INDIR'))) as DIRINDIR.

 

I want to create this new column DIRINDIR in a similar way.

Anonymous
Not applicable

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.