Re: Looking to calculate/generate a value from two...

sjw · ‎04-10-2019

Looking to calculate/generate a value from two independent tables in Power BI and show this value in a calculated column using measures or in a new table to model on it.

Currently have a master table, which has all the required information to fill the output tables new Price column.

Master Table - Projects, Type of product (Multiple Options Per Project) and Price of product

Output Table - Looking to generate a column for the Price. If Ready column is yes...need to match the Project and Type to pull the relevant Price for the Master Table.

Or, add a column to the master table as a calculated measure

parry2k · ‎04-10-2019

@sjw can you share sample data with expected ouput, it will help to get your answer

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

sjw · ‎04-12-2019

@parry2k can you support with the issue we posted on querying cross tables to calculate new values for products. Much appreciated!

sjw · ‎04-11-2019

Enclosed are the master table and output expected from calculation

v-chuncz-msft · ‎04-17-2019

@sjw ,

Just try IF and LOOKUPVALUE to add a calculated column.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.