power bi relationship

v-chuncz-msft

Okay. It's normal to study ... what I'm going to do next.
But coming back to my situation ... what I want to get is like that:
  We have the product A, which has a code_item to call it "a1", a name - "product a" and a stock at the beginning and a end stock of the month.
This product A appears in a month several times with different values.
Appears in month 1 through month 12.
I want with the help of power bi in month 1 for product A to make the calculation at all stock values at the beginning of the month and at the stock end of the month.
In the results table I will only display once the information: "product a", code_item "a1", stock started month (gather all the values found in the month and display their total), end month stock (add all the values found in that month and display their total), product name "product a", month.
The formula written by you gives me 95% of the result, because the results do not tell my product name nor the month.