Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

getting the sum of a column exactly 12 month ago

hey guys, 

 

have been trying to work something out but till now each aproach isnt giving me the correct result or its failing, 

 

need to determine a dax that takes as reference today dates, send me back this exact date 12 month ago and sum a column in that time period exactly, here my last attemp:

Ordenado Mes -1 = 
var actualdate = TODAY()
var fechainicial = STARTOFMONTH(DATEADD( 'Fecha Contibilización'[Date] ,-1,MONTH))
var fechafinal = MAX( ENDOFMONTH(DATEADD( 'Fecha Contibilización'[Date] ,-1,MONTH)))
var codigoarticulo = 'Query Inventario Maestro'[Codigo Articulo Corregido]
return 
CALCULATE(SUM('Reporte Ordenes'[Cantidad] ), 'Reporte Ordenes'[Codigo Articulo] =codigoarticulo, 'Reporte Ordenes'[Fecha Contabilizacion] >= fechainicial,'Reporte Ordenes'[Fecha Contabilizacion] <= fechafinal)




Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




1 ACCEPTED SOLUTION
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

never mind found the soluction, 

Ordenado Mes -1 = 
var intervalo = -2
var codigoarticulo = 'Query Inventario Maestro'[Codigo Articulo Corregido]
var fechainicial =  TOPN(1, DATESINPERIOD('Reporte Ordenes'[Fecha Contabilizacion], TODAY(), intervalo ,MONTH))
var fechafinal =  ENDOFMONTH(fechainicial)
return
CALCULATE(SUM('Reporte Ordenes'[Cantidad] ), 'Reporte Ordenes'[Codigo Articulo] =codigoarticulo, 'Fecha Contibilización'[Date] >= fechainicial,'Fecha Contibilización'[Date] <= fechafinal)




Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

1 REPLY 1
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

never mind found the soluction, 

Ordenado Mes -1 = 
var intervalo = -2
var codigoarticulo = 'Query Inventario Maestro'[Codigo Articulo Corregido]
var fechainicial =  TOPN(1, DATESINPERIOD('Reporte Ordenes'[Fecha Contabilizacion], TODAY(), intervalo ,MONTH))
var fechafinal =  ENDOFMONTH(fechainicial)
return
CALCULATE(SUM('Reporte Ordenes'[Cantidad] ), 'Reporte Ordenes'[Codigo Articulo] =codigoarticulo, 'Fecha Contibilización'[Date] >= fechainicial,'Fecha Contibilización'[Date] <= fechafinal)




Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.