Creating an Inventory Analysis by Date

[acbi]

Hello there,

I have the following table:

Each line corresponds to an update on the inventory of a given product in a given store in a particular type of inventory.

I need to always get the latest date, because in one day there may be more than one change. I want to generate a temporal graph with the data.

I tried several methods but I did not succeed.

Thank you.

[v-yuta-msft]

@acbi,

---

Each line corresponds to an update on the inventory of a given product in a given store in a particular type of inventory.

I need to always get the latest date, because in one day there may be more than one change. I want to generate a temporal graph with the data.

I tried several methods but I did not succeed.

---

Could you share more details about your expected results and post the current dax formula you are using?

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.