cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

La expresión hace referencia a varias columnas. No se pueden convertir varias columnas en un valor escalar.

hiii

Yo estaba usando esta fórmula para calcular la espera tym < 60 seg, pero muestra un error

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

@greeshma , si intenta crear una columna

a continuación, tratar de

flag: if([tiempo de espera] <time(0,1,0),1,0)

si medida entonces

measure- calculate(Sum(Table[wait time),filter(Table, Table[wait time] <time(0,1,0)))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

@greeshma , si intenta crear una columna

a continuación, tratar de

flag: if([tiempo de espera] <time(0,1,0),1,0)

si medida entonces

measure- calculate(Sum(Table[wait time),filter(Table, Table[wait time] <time(0,1,0)))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Community Support
Community Support

Hola @greeshma ,

Si es una medida, modifíquela como se indica a continuación:

wait tym<60=Calculate(max('Phone Call Data'[waiting tym]),FILTER('Phone Call Data','Phone Call Data'[waiting tym]<TIME(0,0,60)))

Si es una columna, utilice la siguiente expresión:

wait tym<60=IF('Phone Call Data'[waiting tym]<TIME(0,0,60),'Phone Call Data'[waiting tym],BLANK())

Saludos
Kelly
¿He respondido a tu pregunta? ¡Marca mi puesto como una solución!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors