Forum Discussion
Solved
Using DAX How to Create a new table from existing tables
Hello Power BI community, A very simple question on creating a new table in Power BI. Please find below as a data Table 1 | CANDY | OFFICE | |--------|------------| | Nomi | Challakere | ...
Try:
Table 3 = SELECTCOLUMNS ( 'Table 1', "Candy", 'Table 1'[CANDY], "Producer", LOOKUPVALUE ( 'Table 2'[PRODUCER ID], 'Table 2'[OFFICE], 'Table 1'[OFFICE] ) )
you can use merge queries as nwe and select required colmns in PQE. otherwise use joins in DAX
Can You Please Write Down DAX Function here
Try:
Table 3 = SELECTCOLUMNS ( 'Table 1', "Candy", 'Table 1'[CANDY], "Producer", LOOKUPVALUE ( 'Table 2'[PRODUCER ID], 'Table 2'[OFFICE], 'Table 1'[OFFICE] ) )