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

Regular Visitor

## calculate period

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(
,REMOVEFILTERS(tab_registros)
,FILTER(ALL(tab_registros),tab_registros[fecha_zarpe]>=fechainiant && tab_registros[fecha_zarpe]<=fechafinant)
)
From already thank you very much
1 ACCEPTED SOLUTION
Regular Visitor

@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(
,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])
)
2 REPLIES 2
Regular Visitor

@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(
,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])
)
Regular Visitor

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 =

prueba2 =

``````prueba2 =

Best of luck!

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.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors