Forum Discussion

kjani's avatar
kjani
Helper I
6 years ago
Solved

DAX help for calculation from multiple tables

Here are my 3 inputs and desired output. Can you help?

 

 

Need Help
  • nandic's avatar
    nandic
    6 years ago

    kjani ,

     

    First you need relationships between tables.
    Example:



    Select Usage table and add new column:

    Output expected = RELATED(Rates[Rate])*Usage[Usage]




3 Replies

  • nandic's avatar
    nandic
    Resident Rockstar
    6 years ago

    kjani ,

     

    First you need relationships between tables.
    Example:



    Select Usage table and add new column:

    Output expected = RELATED(Rates[Rate])*Usage[Usage]




  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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.

    • kjani's avatar
      kjani
      Helper I
      6 years ago

      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.