Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
@parry2k can you support with the issue we posted on querying cross tables to calculate new values for products. Much appreciated!
Enclosed are the master table and output expected from calculation
@sjw ,
Just try IF and LOOKUPVALUE to add a calculated column.
Thank you. To clarify, when writing DAX, we are having difficulties with querying IF & LOOKUPVALUE in the same command.
Can you show/advise how this would be presented in a Query.
Enclosed are the master table and output expected from calculation
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |