Forum Discussion
Solved
help calculation
First of all, please excuse my lack of knowledge in making this inquiry. I have two tables, one for open tickets and another for closed tickets, and a table of dates (calculate dates). I have a dis...
rakelvillanueva Have a look at this, I created this specifically for the purpose you are describing:
Hi rakelvillanueva please try this
Tickets Open on Date =
VAR FechaSeleccionada =
SELECTEDVALUE('date'[Date])
RETURN
CALCULATE(
COUNTROWS(Merge1),
FILTER(
ALL(Merge1),
Merge1[Apertura] <= FechaSeleccionada &&
(
ISBLANK(Merge1[TICKETS_CERRADOS.Resolucion]) ||
Merge1[TICKETS_CERRADOS.Resolucion] > FechaSeleccionada
)
)
)