Forum Discussion

Unknown_1's avatar
Unknown_1
Frequent Visitor
2 years ago
Solved

undefined

Hi Team,

I have created a visual based on some dataset in power bi.

My next target is to have a simple vlookup on the visualized results.

I want to Find LE CBU in CBU Legal Entity when a match is found I want to Return the AP transaction amount in a new column.

Please can somebody help me here how can I acheive this.

Thank you!

 

 

Vlookup Dax Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Unknown_1 

     

    Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

    DAX:

     

    New AP Transaction Amount = 
CALCULATE(
    SUM('Table'[AP Transaction Amount]),
    FILTER(
        ALL('Table'),
        'Table'[CBU Legal Entity] = EARLIER('Table'[LE CBU])
    )
)

     


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Unknown_1 

     

    Based on your description, I have created some measures to achieve the effect you are looking for. Following picture shows the effect of the display.

    DAX:

     

    New AP Transaction Amount = 
CALCULATE(
    SUM('Table'[AP Transaction Amount]),
    FILTER(
        ALL('Table'),
        'Table'[CBU Legal Entity] = EARLIER('Table'[LE CBU])
    )
)

     


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum