How to create a cross table with measures?

[EshaanG]

Hello,

I have two tables : Revenue & Sales which has numbers at a quarterly level by Geo. In both tables, I have calculated measures for Total, Q/Q Change & Y/Y Change. How do I create a new table which has the measures as rows and the calculations as Columns for e.g.

Measure     Geo        Total          Q/Q Change          Y/Y Change

Revenue     APAC        100                10%                        17%

Revenue     NA            100                15%                        21%

Revenue     WW          200                12%                        19%

Sales          APAC        150                10%                        17%

Sales          NA            180                15%                        21%

Sales          WW          225                12%                        19%

Will measure tables help? Please advise

[v-deddai1-msft · Accepted solution]

Hi @EshaanG ,

You can use the below calculated column:

Table = UNION(ROW("Type","Revenue","Total",[Total for Revenue],"Q/Q Change",[Q/Q Change for Revenue],"Y/Y Change",[Y/Y Change for Revenue]),ROW("Type","Sales","Total",[Total for Sales],"Q/Q Change",[Q/Q Change for Sales],"Y/Y Change",[Y/Y Change for Sales]))

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

Best Regards,

Dedmon Dai

[PaulDBrown]

Here is a thread which covers how to create a table using measures for rows and columns:

Creating a table with measures for rows and columns