Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Unknown_1
Frequent Visitor

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!

1000216051.jpg

 

1 ACCEPTED SOLUTION
v-yaningy-msft
Community Support
Community Support

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.

vyaningymsft_0-1713146849693.png

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

View solution in original post

1 REPLY 1
v-yaningy-msft
Community Support
Community Support

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.

vyaningymsft_0-1713146849693.png

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

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.