Forum Discussion

joaquinel's avatar
joaquinel
Helper I
3 years ago
Solved

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()))
 
Thanks in advance.
Need Help
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    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

  • mangaus1111's avatar
    mangaus1111
    Solution Sage
    3 years ago

    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.