union in report

[River]

Hi Friends,

We want to build a revenue report, which include sales order, interests, free text invoice items. 

Those are from different tables, with quite different columns. How can we build a union to present data in report.

Many thanks!

[V-pazhen-msft]

@River 

Yes, It is join. Because with Union the tables must have the same number of columns which usually not the case.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@River instead of spending time going back and forth why not you share sample data and expected output. Did you have a chance to read the post I shared earlier? If you help us we will able to help you.

here is the link to the post again.

Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[V-pazhen-msft]

@River 

The shot answer is you can related the tables with a column (product or date, etc), once relationship is activated, you could put the columns in one visual. However, it is very much depended on your model so more information is required for a detailed solution.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[River]

Hi Paul,

When you link them through a column, isn't it a join not union?

[parry2k]

@River it is a very vague question. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490