Forum Discussion

OlegV's avatar
OlegV
Icon for Helper III rankHelper III
2 years ago
Solved

create a table visual based on 2 tables (no calculated columns, tables or relationships)

Hello, I have two power bi dax tables.  I need to create a table visual. In which the first column is 'Sales Orders'[Sales Order], the second column is 'WiPJobs'[Job]. I cannot create new caculate...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi OlegV ,

 

Thank you Greg_Deckler  for the quick response and solution. In addition to creating a measure, we can also create a new table.

 

NewTable =
ADDCOLUMNS (
    'SalesOrders',
    "Job",
        CONCATENATEX (
            FILTER ( 'WIPJobs', [Sales Order] = EARLIER ( 'SalesOrders'[Sales Order] ) ),
            [Job],
            ","
        )
)

Best Regards,

Neeko Tang

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