Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

SI LA FECHA ENTRE FECHAS

Tengo4 columnas de fechas dentro de la tabla (OT) y quiero crear una medida que cuente las condiciones "L" Y "E"

por ejemplo: IF DATE 2 <DATE 3 llega tarde a "L" y si FECHA 1> FECHA 4 es temprano "E". FECHA DE FINALIZACIÓN. Podrían ser 2 medidas una para la condición L y la otra para E

D1D2D3D4
31/08/2020 7:3031/08/2020 9:3031/08/2020 8:0731/08/2020 8:08
31/08/2020 8:0031/08/2020 10:0031/08/2020 8:1731/08/2020 8:21
31/08/2020 8:3031/08/2020 8:3031/08/2020 8:2631/08/2020 8:47
31/08/2020 8:3031/08/2020 10:3031/08/2020 8:5731/08/2020 9:02

gracias por la ayuda!

2 REPLIES 2
amitchandak
Super User
Super User

@ALVARO1993 , si necesita columna

switch()( True(),
[D2 < [D3], "L"
[D1]> [D4], "E")

Medida
tarde: calculate(countrows(Table), filter(Table,[D2 < [D3]))
early: calculate(countrows(Table), filter(Table,[D1]> [D4]))

camargos88
Community Champion
Community Champion

@ALVARO1993 ,

Prueba estas medidas con un objeto visual de tarjeta:

_Early = COUNTX('Table', IF('Table'[D1] > 'Table'[D4], 1, BLANK()))
_Late = COUNTX('Table', IF('Table'[D2] < 'Table'[D3], 1, BLANK()))



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

Proud to be a Super User!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors