Automatically create tables in Power BI

[Analitika]

Hello,

I wonder how to automatically create tables according to company name an column x?

[v-chenwuz-msft]

Hi @Analitika ,

Yes, you can use CROSSJOIN( VALUES( 'Table1'[Company name]) , VALUES( 'Table2'[column x]) to create a table automatically.

Or you can refer to this function.

CROSSJOIN function (DAX) - DAX | Microsoft Docs

If I misunderstood you, please share example data and expect result. Or refer to this article on how to get the answers you want quickly.

How to Get Your Question Answered Quickly

Best Regards

Community Support Team _ chenwu zhu

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