Combine three dimensional tables in PoweBI DAX

[Rikats]

Hello!

I need help in PoweBI DAX, how can I combine data like this? I get every week data in excel three dimensional table and I need to combine like I highlighted in green.

Data:

Enterprise	01.10.2023	01.10.2023	01.10.2023	02.10.2023	02.10.2023	02.10.2023	03.10.2023	03.10.2023	03.10.2023
	Income	Clients	Operations	Income	Clients	Operations	Income	Clients	Operations
LTD "ABC"	1000	50	100	4300	87	5423	10041	853	4232
LTD "Toys"	2500	10	424	3120	47	3123	15712	976	2345
LTD "Dunno"	3000	30	541	5243	98	5243	34221	473	3263

Enterprise	01.11.2023	01.11.2023	01.11.2023	02.11.2023	02.11.2023	02.11.2023	03.11.2023	03.11.2023	03.11.2023
	Income	Clients	Operations	Income	Clients	Operations	Income	Clients	Operations
LTD "ABC"	1123	173	223	4423	210	5546	10164	976	4355
LTD "Toys"	2623	133	547	3243	170	3246	15835	1099	2468
LTD "Dunno"	3123	153	664	5366	221	5366	34344	596	3386

[Anonymous · Accepted solution]

Hi @Rikats ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) Click on "merge queries" in the home tab of power query.

(3)Expand the table.

(4) Then the result is as follows.

Unfortunately Power BI doesn't support multidimensional tables so duplicate column headings can't exist, you can manually change the column headings adding spaces to make the headings inconsistent.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Rikats]

Thank you 🙂

[Rikats]

Up ^

Please help