none
Power Query_ DAX formula RRS feed

  • Question

  • I have two sets of table of data (Table 1, Table 2).

    I would like to produce Table 3 – Desired Table in Power BI Query.

    Table 1

     

    TicketID

    Volume

    111

    25

    222

    -10

    333

    50

    444

    -20

    Table 2

     

    TicketID_ToJob

    TicketID_ From Job

    111

    222

    333

    444

    Table 3: Desired Table

     

     

     

    TicketID

    TicketID_ToJob

    TicketID_ From Job

    Volume_ToJob

    Volume_FromJob

    111

    111

    25

    222

    222

    -10

    333

    333

    50

    444

    444

    -20

    Please advised the best approach to produce Table 3 outcome.

    Thanks in advance.

    Tuesday, May 28, 2019 6:17 AM

Answers