cancel
Showing results for
Did you mean:
Helper I

## Using SAMEPERIODLASTYEAR with MIN date

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()))

1 ACCEPTED SOLUTION
Solution Sage

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.

2 REPLIES 2
Solution Sage

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.

Helper I

Great!!!