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 ...
dilumd's avatar
dilumd
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hi

 

Without looking at your data model it's difficult to give you a proper solution, (if possible share with me some dummy data of your two tables) however I tried to imitate your scenario and my PBIX file is attached.

 

kindly check my steps and check whether you’re getting the result you want. 

 

https://www.dropbox.com/s/mtmtgzd0xcfluq4/maximus1.pbix?dl=0

maximus1's avatar
maximus1
Frequent Visitor
9 years ago

dilumd,

 

Thank you for your help. I tried to replicate your formula but I still get an error message.

 

Under my August Production, I tried to replicate your formula as a new measure and as a new column and get an error on both. 

 

I have attached my data below. Thank you for taking the time, i really appreciate all the help.

 

 

 

https://www.dropbox.com/s/m9vv6zbxjjtebu9/August%20Harvest.pbix?dl=0

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft 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
        Icon for Microsoft Employee rankMicrosoft 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, dilumd!

       

      I will definitely spent some time learning DAX. I appreciate all your help. If there is any books on DAX that you would recommend please let me know.