calculate period

[cristianperezc]

Please help me, I have the requirement to calculate totals for 2 periods, but based on an initial date, for example I have the total for period 1 of a segment 09/01/2022 - 09/30/2022 and the idea is to bring totals automatically corresponding to the period 09/01/2021 - 09/30/2021, apply a measure but this brings me the grand total for all rows

code dax measure

prueba2 =

 var fechainiant= ([FechaIniTempAnt]) RETURN

 var fechafinant= ([FechaFinTempAnt]) RETURN

  CALCULATE(

     sum(tab_registros[toneladas])

     ,REMOVEFILTERS(tab_registros)

     ,FILTER(ALL(tab_registros),tab_registros[fecha_zarpe]>=fechainiant && tab_registros[fecha_zarpe]<=fechafinant)

)

From already thank you very much

[cristianperezc · Accepted solution]

@Hipnobe Thank you very much for your response and collaboration, I had already carried out those tests, however I applied some custom settings and the problem was solved, I leave the solution here in case someone requires it

prueba2 =

 var fechainiant= ([FechaIniTempAnt]) RETURN

 var fechafinant= ([FechaFinTempAnt]) RETURN

 CALCULATE(

     sum(tab_registros[toneladas])

     ,REMOVEFILTERS(tab_registros[temp_seq_nro],tab_registros[fecha_zarpe])

     ,FILTER(ALL(tab_registros),tab_registros[fecha_zarpe]>=fechainiant && tab_registros[fecha_zarpe]<=fechafinant)

     ,VALUES(tab_especies[cod_especie])   

)

[Hipnobe]

Hello,

First, it doesn't look like you have a date table. If not, I recommend you to start creating one.

Then, can you try to make 2 seperate measures: 1 for N and the 2nd one for N-1 (prueba2 in your example).

The measure to compute N:

Toneladas N =

Toneladas N =
SUM(tab_registros[toneladas])

prueba2 =

prueba2 =
CALCULATE ( [Toneladas N], DATEADD ( Date[Date], -1, YEAR ) )

Best of luck!