Breaking down a table in multiple tables

Hi, I have obtained data from SQL Server into Power Bi. The data is basically a query that is collected through various tables and then placed into one single table through multiple columns.
Now in Power BI, I want to break this table into a number of tables and create a fact table as well. I was wondering how can I accomplish this task.

Thank you.

Kind regards,
Modasher.

Hi Modasher,

Please take some time to work through this course

and pay special attention to the section:

1 Like

To the contributors of this post, thank you for all your inputs on this topic we are now tagging it as Solved. To help us learn more about your experience in the forum, please take a moment to answer this short forum survey. We appreciate all your help and suggestions. Thanks!