topic Re: Query based on tables without relations? in DAX Commands and Tips

Query based on tables without relations?

Cipriano — Wed, 23 Nov 2022 23:01:56 GMT

Hello everyone!

I have 3 tables that are not related, and I need to get a combined query, I tried to use UNION and SELECTCOLUMNS, but it was not possible.

first table

fechaid_productid_facilityconsumoprograma

second table

fechaid_productid_facilityexistenciarecibido

third table

fechaid_facilityvolumen

expected result

fechaid_productid_facilityconsumoprogramaexistenciarecibidovolumen

any ideas, Thank you very much in advance.

PBIX-file: Query

FreemanZ — Thu, 24 Nov 2022 00:35:32 GMT

you can treat unrelated table columns as related ones with TREATAS function. https://dax.guide/treatas/

v-xiaosun-msft — Fri, 25 Nov 2022 07:21:10 GMT

You can use "Merge Queries as new" in Power Query and the expand the columns you need.

Final output:

Or you can try what FreemanZ suggested to use TREATAS function which is best for use when a relationship does not exist between the tables.

You can reference the following document.

Best Regards,
Community Support Team _ xiaosun

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