cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors