cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Calcular el recuento total para la fecha de hoy

Hola miembros del grupo, estoy atrapado en una situación en la que tengo que averiguar: 1-Número de problemas abiertos a partir de la fecha de hoy (Incluido el artículo fechado pasado si está abierto) 2-Número de problemas abiertos después de la fecha de hoy.

Por favor, ayó. Gracias.

Estado del billete Ultima fecha para cerrar

XXX Cerrado 04-09-2020

ABC Open 01-09-2020

DFG Open 31-08-2020

GHJ Cerrado 01-09-2020

FHT Abierto 10-09-2020

FGH Abierto 15-09-2020

2 ACCEPTED SOLUTIONS
Super User IV
Super User IV

@saurabhsahu0111 , Probar como

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] ?<today()) ? (tabla[Estado] á"Cerrado" && [Fecha de cierre] >today())))

O

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] <today())))

O

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] <- today())))



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

Super User IV
Super User IV

@saurabhsahu0111 - Parece que:

Measure 1 = COUNTROWS(FILTER('Table',[Status]="Open" && [Last Date to Close] <= TODAY())

Measure 2 = COUNTROWS(FILTER('Table',[Status]="Open" && [Last Date to Close] > TODAY())

Siento que me estoy perdiendo algo.

Usted puede encontrar esto útil -
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
Community Support
Community Support

Hola @saurabhsahu0111

Si la ayuda de las publicaciones anteriores, por favor márquela como una respuesta para ayudar a otros a encontrarla más rápidamente. ¡Gracias!

Si no, por favor, amablemente elaborar más.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Super User IV
Super User IV

@saurabhsahu0111 - Parece que:

Measure 1 = COUNTROWS(FILTER('Table',[Status]="Open" && [Last Date to Close] <= TODAY())

Measure 2 = COUNTROWS(FILTER('Table',[Status]="Open" && [Last Date to Close] > TODAY())

Siento que me estoy perdiendo algo.

Usted puede encontrar esto útil -
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Super User IV
Super User IV

@saurabhsahu0111 , Probar como

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] ?<today()) ? (tabla[Estado] á"Cerrado" && [Fecha de cierre] >today())))

O

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] <today())))

O

calculate(countrows(Table), filter(Table, (table[Status] á"Open" && [Last Date to close] <- today())))



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

Gracias @amitchandak por la resolución, está funcionando.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

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.