undefined

Unknown_1 — Fri, 12 Apr 2024 11:10:35 GMT

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!

Re: undefined

Anonymous — Mon, 15 Apr 2024 02:09:21 GMT

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

topic Re: undefined in DAX Commands and Tips

undefined

Re: undefined