cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

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
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

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
Top Kudoed Authors