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_B...
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)))
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)))