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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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