IF Function & Filter Help

Anonymous — Fri, 12 Jul 2024 20:58:14 GMT

The Goal is to have one column that generates "SDR Gen" is the SRD Name and AE Name are not blank, and generate "Self Gen" if the SDR name is blank and the AE Name is not blank. Here are the two formulas I have tried, any tips?

SDR Gen = (IF(Opportunity[SDR Name]<> BLANK() && Opportunity[AE Name]<>BLANK(), "SDR Gen"), IF(Opportunity[SDR Name]= BLANK() & Opportunity[AE Name]<> BLANK(), "Self Gen", BLANK()))

SDR Gen = (IF(Opportunity[SDR Name]<> BLANK(), "SDR Gen", "Self Gen"), FILTER(Opportunity, Opportunity[AE Name]<> BLANK()))

Any suggestions on how to make this work would be greatly appreciated.

Re: IF Function & Filter Help

Irwan — Fri, 12 Jul 2024 23:02:38 GMT

hello Anonymous ,

please check if this accomodate your need.

SDR Gen =

IF(

not ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),

"SDR Gen",

IF(

ISBLANK('Table'[SRD Name])&&not ISBLANK('Table'[AE Name]),

"Self Gen",

BLANK()

))

Hope this will help you.

Thank you.

topic IF Function & Filter Help in DAX Commands and Tips

IF Function & Filter Help

Re: IF Function & Filter Help