Using SAMEPERIODLASTYEAR with MIN date

[joaquinel]

Hi,

I need to count the number of accumulated contracts (formula below) per month. Then I need the same calculation to compare with the last year.

At this point is when I can not continue. I don't know where or how use SAMEPERIODLASTYEAR.

The Fact table is "ContratosServicio" and the Calender table "Calendario".

15_TotalBOPLastPeriod =

 CALCULATE(COUNT(ContratosServicio[Id]),

filter(

    ALLEXCEPT(ContratosServicio,ContratosServicio[IdCentroContratacion],ServiciosContratables[IdTipoServicio] ),

      ContratosServicio[FechaAlta] < min(calendario[date]) && ContratosServicio[FechaBaja] = BLANK()))

Thanks in advance.

[mangaus1111 · Accepted solution]

Hi @joaquinel ,

I think you have to use this measure

CALCULATE(

                   [15_TotalBOPLastPeriod],

                  SAMEPERIODLASTYEAR('calendario'[date])

       )

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[joaquinel]

Great!!!