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!
Necesito crear una columna que muestre la suma de un importe por fecha, omitiendo lo que indique el resto de las columnas.
Por ejemplo:
Como en este caso, la columna USD por fecha, suma todos los importes de cada fecha, sin tener en cuenta el código del producto.
qué fórmula debo usar?
Fecha de Venta | CODIGO_PRODUCTO | USD | USD POR FECHA |
31/8/2019 | 101009000020 | 130983,315 | 178056,9825 |
31/8/2019 | 105001000020 | 47073,6678 | 178056,9825 |
31/7/2019 | 107001000001 | 17088,4373 | 37435,12083 |
31/7/2019 | 103009000020 | 20346,6835 | 37435,12083 |
30/6/2019 | 103002000001 | 91646,8248 | 157566,2641 |
30/6/2019 | 101009001000 | 34699,9553 | 157566,2641 |
30/6/2019 | 107006000020 | 31219,4839 | 157566,2641 |
31/1/2018 | 105008000010 | 12980,0623 | 20463,80062 |
31/1/2018 | 106010000000 | 7483,73832 | 20463,80062 |
Aguardo sus comentarios, desde ya muchas gracias.
Solved! Go to Solution.
Hi @mmazzalay ,
You can create column or measure like DAX below.
Column1= CALCULATE(SUM(Table1[USD]),FILTER(ALLSELECTED(Table1),Table1[Fecha de Venta]=EARLIER(Table1[Fecha de Venta]))) Measure1= CALCULATE(SUM(Table1[USD]),FILTER(ALLSELECTED(Table1), Table1[Fecha de Venta] =MAX(Table1[Fecha de Venta])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mmazzalay ,
You can create column or measure like DAX below.
Column1= CALCULATE(SUM(Table1[USD]),FILTER(ALLSELECTED(Table1),Table1[Fecha de Venta]=EARLIER(Table1[Fecha de Venta]))) Measure1= CALCULATE(SUM(Table1[USD]),FILTER(ALLSELECTED(Table1), Table1[Fecha de Venta] =MAX(Table1[Fecha de Venta])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |