cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
OleMcDonald
Helper I
Helper I

Si ANY es verdadero VERDADERO/FALSO

No estoy seguro de por qué lucho tanto con esta lógica

Estoy tratando de decir si cualquiera de estos son verdaderos entonces returen verdadero

if [HasOptedOutOfEmail]=true 
or
[Unsync_with_Marketo__c] = true 
or 
[JobGroups]="Other"
or
[Engagement_Status__c]="Disqualified - Duplicate" 
or
[Engagement_Status__c]="Disqualified - No Longer Employed"  
or 
[Engagement_Status__c]="Disqualified - Opt-out Requested" 
or
[Engagement_Status__c]="Disqualified - Data Issue" 
 
[Engagement_Status__c]="Disqualified - Competitor" 
or 
[Engagement_Status__c]="N/A - Partner Contact" 
or 
[Engagement_Status__c]="N/A - Press / Analyst Contact" 
or 
[Engagement_Status__c]="Nurture - Region Not Serviced" 


then true 

else false

1 ACCEPTED SOLUTION
littlemojopuppy
Super User I
Super User I

Prueba esto...

SWITCH(	
	TRUE(),
	[HasOptedOutOfEmail] = TRUE() , TRUE(),
	[Unsync_with_Marketo__c] = TRUE() , TRUE(),
	[JobGroups] = "Other", TRUE(),
	.
	.
	.
	[Engagement_Status__c] = "Nurture - Region Not Serviced", TRUE(), 
	FALSE()
)

View solution in original post

5 REPLIES 5
littlemojopuppy
Super User I
Super User I

De nada. Este es un vínculo a la documentaciónde Microsoft para DAX . Muy útil para mantener alrededor de 😉

littlemojopuppy
Super User I
Super User I

Prueba esto...

SWITCH(	
	TRUE(),
	[HasOptedOutOfEmail] = TRUE() , TRUE(),
	[Unsync_with_Marketo__c] = TRUE() , TRUE(),
	[JobGroups] = "Other", TRUE(),
	.
	.
	.
	[Engagement_Status__c] = "Nurture - Region Not Serviced", TRUE(), 
	FALSE()
)

View solution in original post

Nunca supe de SWITCH.. Esto funcionó y se ha convertido en mi nuevo mejor amigo.

Necesito investigar más al respecto

Gracias a todos

NikhilKumar
Super User II
Super User II

Probablemente porque le falta un quirófano entre el problema de datos y el competidor


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

Buen ojo Nikhil

Lo eliminé de la publicación por accidente cuando intenté formatear el texto. En realidad existía en mi código

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Kudoed Authors