lookup the related month in related table

[Mamtas]

I am very new to DAX. Please help

I have these two tables connected by "Centre"

I have a slicer showing 'Month' from YTD table

Then a table measure showing the 

Centre, Average of Booked session. I want to add a new column there from second table "Budgets"

So when in slicer i click Dec 23, the table shows Centre name,  "Avg of booked Sessions", But i also want to show the budget % from budget table as per the Month. So when you click on Dec 23, its show Dec % from Budget table and when i click Jan 24, it shows Jan % for that centre

YTD Table

Centre	Booked session	Month
ABC	40	Dec-23
ABC	30	Dec-23
ABC	50	Jan-24
ABC	30	Jan-24
DEF	40	Dec-23
DEF	80	Dec-23
DEF	90	Jan-24
DEF	70	Jan-24

Budgets table

Centre	2023-12	2024-01
ABC	87%	80%
DEF	60%	50%

[Fowmy · Accepted solution]

@Mamtas 

To do that, you first need to create a new table with Center, Month and Budget %, where you will have all the % values in a column layout, the current layout of the Budget Table can be copied in Power Query do unpivot. The, You can create a relationship between the Budget Table and the New Table. I also added a dates table for proper modeling. 

Please check the attached file.

[Mamtas]

Thanks so much. I am exporting the data Excel, so you mean first manuplate the data in Excel and export and make the 2 new tables in PBI.  Or these new tables can be created straight in PBI?

[Fowmy]

@Mamtas 

Please refer the attched Power BI file, go to Power Query and check. You can reference the source table and do the manipulation in it.