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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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