Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Nested If() in Power Edit Query

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.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago
    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)))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    plz help me anyone 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    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)))