Compare variation in inventory aging between dates using targeting targeting

[prabhuk]

Hello everyone

I'm very new to Power Bi and would like to compare the difference in the inventory aging report between two days selected using data segmentation.

I have data like date wise product and is quantity, value and aging cube(0-30 days,31-60 days,61-90 days and > 90 days)

Now I would like to view and compare by selecting two dates (for example, April 15 and April 30) as below screenshot shown. If I change the first date or second date dynamically, all information must change.

sample date attached as photo.

I've prepared the table in BI for a certain date, but I have no idea how to bring inventory information from two dates and the difference between dates.

Please help with formulas to get this in Power Bi.

[v-chuncz-msft]

@prabhuk 

See solution in post below.

https://community.powerbi.com/t5/Desktop/Compare-variation-in-inventory-aging-between-dates-using/m-...

[MFelix]

Hi @prabhuk ,

There is no image on the post, can you share a sample file and how your data is setup?

Please see this post regarding How to Get Your Question Answered Quickly (courtesy of @Greg_Deckler) and How to provide sample data in the Power BI Forum (courtesy of @ImkeF).