Forum Discussion

joaquinel's avatar
joaquinel
Icon for Helper I rankHelper I
3 years ago

Filtred with two differents dates

Hi,

 

I need to count my data filtered by two dates. The main report has the filter according with my Calender Table, which is one of the fields of dates that I need, but I don't know how to adress the second one. It should be as below.

 

In the example only should count the two firsts lines

 

IdFechaCobroFechaIniciValidez
102/01/202302/01/2023
202/01/202302/01/2023
302/01/202302/02/2023

 

CALCULATE

        (
            COUNT
                (
                    Pagos[IdPersonaOrigen]
                ),
                    Pagos[CuentaContable] = "70810030",
                    USERELATIONSHIP( Pagos[FechaInicioValidez],'1CalFCobro'[Date]  )
          )
 
 
Need Help
No RepliesBe the first to reply