Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hola bue dia:
estoy intentando calcular el acumulado del año para las ventas pero tengo diferentes categorias y quiero que el acumulado sea independiente:
ejemplo:
Mes Producto Ventas YTD
ENE ROJO 100 100
ENE VERDE 50 50
FEB ROJO 70 170
FEB VERDE 40 90
MAR ROJO 100 270
MAR VERDE 50 140
y asi sucesivamente.... agradezco muchos sus comentarios
saludos
Solved! Go to Solution.
Please mark it as solution so it can help other people
You could just convert your months to a real date and then use DAX Time Intelligence Functions, they will do all the job:
YTD = TOTALYTD(SUM(Tabla1[Ventas]); Tabla1[Fecha])
Hi @Ely,
Based on my test, you could refer to below steps:
Add index column in query editor:
Create a calculated column and now you could see the result.
Column = CALCULATE(SUM(Table2[Ventas]),FILTER('Table2','Table2'[Index]<=EARLIER(Table2[Index])&&'Table2'[Producto]=EARLIER(Table2[Producto])))
Result:
You could download the pbix file to have a view.
Regards,
Daniel He
Thanks a lot for you help, the formula worked correctly....
Please mark it as solution so it can help other people
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |