Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet 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
Hello!
I have a "Product Sale" table with a "Total Boxes" column
I try to add the accumulated "Total Boxes" per month, I tried with the following function: but it goes wrong.
Solved! Go to Solution.
I achieved this with:
I achieved this with:
How are you calculating Cajas Vendidas?
Proud to be a Super User! | |
Are you expecting the result to look like...
Proud to be a Super User! | |
How did you do it?
I used
CALCULATE(
SUM(VentaProductos[Cajas Vendidas]),
FILTER(ALL(VentaProductos), VentaProductos[Fecha de aceptacion] <= MAX(VentaProductos[Fecha de aceptacion]))
)
Proud to be a Super User! | |
Yes, that's what I hope
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |