Power BI generate dynamic grid tables

[analyst101]

Hello,

I'm a newbie to PowerBI...

I'm wanting to generate a dynamic grid table where the first grid will display summary data from the slicer/parameter for Year/Month and the second grid must display summary data for Year-1/Month and the 3rd grid should display granular level data for both....I'm migrating this report from Tableau where I used parameters to get the list of dates from the database and based on the date selected from the dropdown I created calculated fields to calculate Year-1 and also create flags for Grid 1 and 2 to display respective Year/Month summary in the 2 grids and the 3rd grid would display combined granular level data for Grid 1 & Grid 2.
I've attached the pic below and left the 3rd grid blank for the granular data...

Thanks in advance for pointing me in the right direction! 

Raj

sample pbix file 

[analyst101]

@v-jialongy-msft Thank you for the response.

due to the sensitive nature of the data I'm sending a .csv file with summarized totals and current date and previous year date and category.  My aim is if I choose current date(Year/month) from dropdown it should automatically calculate Year-1 and display for same month previous year summarized data and display both in the 2 grids as shown in the image

pbix file attached sample

[v-jialongy-msft]

Hi @analyst101 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny