Forum Discussion

maximus1's avatar
maximus1
Frequent Visitor
9 years ago
Solved

How to divide data from two colums coming from different data sources

Hello, I am new to power bi and exploring its capabilities. I have built a table from two different data sources (August Payroll and August Production).  I have created a relationship between these ...
v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi maximus1,

 

In addition to dilumd's solution, you should also be able to simply use the formula below to create a measure to calculate Boxes per Hour in this scenario. :smileyhappy:

Measure = DIVIDE(SUM('August Production'[Boxes]),SUM('August Payroll'[Hours]))

 

Regards

maximus1's avatar
maximus1
Frequent Visitor
9 years ago

v-ljerr-msft

 

Thank you for your help! I appreciate the alternative solution. If you know of any resources that would be helpful in learnig DAX please let me know. I am new to power bi, but really want to learn.

 

Thank you again!

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi maximus1,

     

    Based on my experience, it's better to start learning DAX from a book, as there are some key concepts needs to be understand first(i.e. the difference between row context and filter context). :smileyhappy:

     

    Regards

    • maximus1's avatar
      maximus1
      Frequent Visitor
      9 years ago

      Thank you!