Nested If() in Power Edit Query

[VenkataRavi]

Dear Group Members,

Please guide me for below mentioned nested IF() need to write in Power Edit Query side.

=IF(OR([@[FB_BAC_CR_SRD]]<>"",[@[FB_BAC_CR_FDD]]<>"",[@[FB_BAC_CR_TDD]]<>"",[@[FB_BAC_CR_Build and UT]]<>""),"BAC_CR",IF([@[Work Item Type]]<>"Task","",RIGHT(L2662,LEN(L2662)-(FIND("on ",L2662)+2))))

Note: above expression belongs to Excel one.

Column L = Title.

Thanks,

Venkata,
Cell: 8309454052.

[VenkataRavi · Accepted solution]

I tried below mentioed DAX it's working fine now.

DAX=IF('Venkat_08CR Research_QM SRD&FDD'[FB_BAC_CR_TDD]<>BLANK() || 'Venkat_08CR Research_QM SRD&FDD'[FB_BAC_CR_Build and UT]<> BLANK()|| 'Venkat_08CR Research_QM SRD&FDD'[FB_BAC_CR_FDD]<>BLANK() || 'Venkat_08CR Research_QM SRD&FDD'[FB_BAC_CR_SRD]<> BLANK(),"BAC_CR",if('Venkat_08CR Research_QM SRD&FDD'[Work Item Type]<> "Task","",

RIGHT('Venkat_08CR Research_QM SRD&FDD'[Title],LEN('Venkat_08CR Research_QM SRD&FDD'[Title])-FIND(" on ",'Venkat_08CR Research_QM SRD&FDD'[Title], ,1)-3)))

[VenkataRavi]

plz help me anyone