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] ) )
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] )
)