How to create historical date column?

[AnamPatel]

I have three tables for three months. All have products data and dates. I want to create a matrix with historical data column that is if a particular product exist in previous month table than that data should be shown as historical date in the matrix visual.

[v-jingzhang]

Hi @AnamPatel 

I agree that merging tables into one table will make it easier. But if you don't want to merge, there are also other solutions. The question is that we are currently not sure what the expected matrix visual should look like so we cannot suggest more. Can you provide some mock data to show the table you have and what the matrix visual should be like? Perhaps you want something like this month's amount (or sales, inventory, price or whatever) and previous month's amount of every product?

Best Regards,
Community Support Team _ Jing

[jaideepnema]

Hi @AnamPatel ,

If these three tables are having similar schema then why dont you merge these three into a single table and basis the date column try to create the matrix visual ?

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀