Forum Discussion
EshaanG
Helper I
Helper IHow to create a cross table with measures?
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 tabl...
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
v-deddai1-msft
Community Support
Community SupportHi 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