Dynamic Column in DATATABLE function

[Anonymous]

Hi All

I want to create a Disconnected Table in order to perform a Switch function with.

BUT I want the columns and rows to populate from two DIM tables namely DIM_Product and DIM_Company.

Every row must contain the name of the either DIM_Product and DIM_Company in the first column and in the second column all the ProductNames and Companynames from the DIM_Product and DIM_Company tables instead of me manually typing them in every time there is an update to those table. thus it must be dynamic...

Is this possible?

@amitchandak 

I want 

[V-lianl-msft]

Hi @Anonymous ,

As far as I know, it can't be achieved. However, you might try to use parameters in the query editor to get data from data source, unlike a dynamic table, which filters the data columns as soon as the data is loaded.

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

[Anonymous]

Hi @V-lianl-msft 

Thank you for your response. 

I am not very familiar with the use of Parameters.

Any words you can share to guide me initially?

[V-lianl-msft]

Hi @Anonymous ,

Please refer to this blog:

https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters/ 

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