I'm having difficulty to building a join/union of three tables that have similar columns, but with different i number of colum and alias on it. In my case I just wanna use the id_number, user, and description and put it in a block of table.
Any idea what I'm doing wrong or how I can get a solution?
I tried DAX using UNION + SUMMARIZECOLUMNS or UNION + SUMMARIZE but didnt work out
For example, this is one of the tables I need to join with three fields in common.
So, I tried your solution, but it didn't work as expected. It joins the data, but in different columns.
What I'm trying to do is to join two tables, as if I'm appending one to each other, but making the same information stay in the same column. Also, the relationship with source tables should be maintained because of the report filters.
It's hard to explain, but it's basically: - column A containing p.number (Problems table) and it.number (ITS table) data - column B containing p.short_description (Problems table) and it.short_description (ITS table).
In the end all those information will be put in a table block to be show together and also able to filtered.