Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
acbi
Frequent Visitor

Creating an Inventory Analysis by Date

Hello there,

 

I have the following table:

 

example.png

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.

 

1 REPLY 1
v-yuta-msft
Community Support
Community Support

@acbi,

 


 

example.png

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.