Combine different tables

[Syndicate_Admin]

Good evening, I am new to this universe and I hope someone can help 🙂 me

I need to visualize in a single graph two axes. One with information from a table of facts containing the detail of all employees for that month-year (this is repeated for each period from Nov-2019). This I manage to graph in a graph of areas and even there everything perfect.

On the other hand I have a table with month-year, country, cant. That is, the vacancies approved for each month-year for that country.

Table 2

There should be two lines, one with the cant of employees and another with the cant of approved positions.

I hope I have been able to convey my problem well.

Thank you very much in advance.

Best regards

[parry2k]

@Syndicate_Admin you need to create a common table that links to both fact tables and then in a visual, you can use a column from the common dimension in this case month and respective value from each fact table, read this post about the star schema Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!