Forum Discussion
River
Helper IV
6 years agounion in report
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 u...
Anonymous
6 years agoNot applicable
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.
- parry2k6 years ago
Super User
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