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 ...
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.

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.

  • joaquinel's avatar
    joaquinel
    Helper I
    3 years ago

    Great!!!