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.
@kjani ,
First you need relationships between tables.
Example:
Select Usage table and add new column:
@kjani ,
First you need relationships between tables.
Example:
Select Usage table and add new column:
@kjani - Do you have relationships between the tables? Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Hello, please find attached additional details along with sample files in CSV.
Relationships:
Rates to Parts_lookup (One to Many using SAP ID)
Parts_lookup to Usage (One to Many using Part ID)
I need to calculate cost for each item (usage table). Each item has multiple parts (part id). Each part has a corresponding SAP id (many parts can have same SAP ID). I have shared 3 sample inputs. Desired output is $30, $66 and $105 respectively for each of the three items.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |