Need help with If then statement

Anonymous — Fri, 25 Oct 2024 17:21:51 GMT

Basically I need something that shows the following:

If MQL is NOT blank, then "MQL"
If SDR is NOT blank and AE is NOT Blank then "SDR Self Gen"
If SDR IS blank and AE is NOT blank then "AE Self Gen"

This is the formula I've been trying but keep getting errors:

Gen Team = IF(Opportunity[Leads Converted.MQL__c] <> BLANK(), "MQL")

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

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

Re: Need help with If then statement

lbendlin — Fri, 25 Oct 2024 17:34:32 GMT

Gen Team = SWITCH(TRUE(), Opportunity[Leads Converted.MQL__c] <> BLANK(), "MQL", Opportunity[SDR Name]<>BLANK() && Opportunity[AE Name]<>BLANK(), "SDR Self Gen", Opportunity[AE Name]<>BLANK(), "AE Self Gen", "Other Gen")

topic Need help with If then statement in DAX Commands and Tips

Need help with If then statement

Re: Need help with If then statement