Hi!
I've a problem in DAX I can't solve. Perhaps you could help me...
In an stock movement table, i have the next columns: Date-time, Product id, Movement id, Order id and Stock.
The final stock value for each product is the number that appears in the column "Stock" in the last date-time and in the last movement for each product.
A product can have multiple movements on the same date-time, so I must figure out the MAX date-time AND the MAX movement id for each product and wrap it up in a CALCULATE.
It seems as a simple DAX formula, but I cant get to it...
Thank you very much in advance!
Baye
I've a problem in DAX I can't solve. Perhaps you could help me...
In an stock movement table, i have the next columns: Date-time, Product id, Movement id, Order id and Stock.
The final stock value for each product is the number that appears in the column "Stock" in the last date-time and in the last movement for each product.
A product can have multiple movements on the same date-time, so I must figure out the MAX date-time AND the MAX movement id for each product and wrap it up in a CALCULATE.
It seems as a simple DAX formula, but I cant get to it...
Thank you very much in advance!
Baye