I have three tables whose structure is as follows-
Table 1-
Table 2-
Table 3-
I wanted to have a table like this -
I tried this particular formula for creating a calculated table-
Table = UNION(SELECTCOLUMNS(Table1,"Table1", Tables[Table1]), SELECTCOLUMNS(Table2, "Table2 Totals", Table2[Totals]), SELECTCOLUMNS(Table3, "Table3 Totals", Table3[Totals]))
The result I am getting is like this:-
I have no idea why this is happening. What to do in this scenario? Do calculated columns not come in merge query?