Forum Discussion
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...
- 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)))
plz help me anyone