Forum Discussion

OlegV's avatar
OlegV
Helper 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
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    OlegV Try:

    Measure = 
    VAR __SO = MAX('SalesOrders'[SalesOrder])
    VAR __Result = CONCATENATEX( FILTER( 'WIPjobs', [SalesOrder] = __SO ), [Job], ", " )
RETURN
    __Result
  • Anonymous's avatar
    Anonymous
    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. 

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.