Forum Discussion

Ricardo_Schmidt's avatar
Ricardo_Schmidt
Regular Visitor
6 years ago
Solved

Dividing values with a determinated rate

Hi everyone,   I'm trying to make a report like the "Expected Table" in the image below using two tables with data. I need to divide the hours of the data in Table 1 into two or more rows using the...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Ricardo_Schmidt ,

    You can use Merge in power query editor to get a new table based on ITEM and ORDER column, expand the PAYMENT and RATIO column from the merged table, close and apply it in power query editor.

    Now you can create a calulated column like this:

    Rated Hours = [HOURS] * [RATIO.RATE]

     The result will be like this:

    Tips: The table visual would not diplay the duplicated rows

     

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Ricardo_Schmidt ,

You can use Merge in power query editor to get a new table based on ITEM and ORDER column, expand the PAYMENT and RATIO column from the merged table, close and apply it in power query editor.

Now you can create a calulated column like this:

Rated Hours = [HOURS] * [RATIO.RATE]

 The result will be like this:

Tips: The table visual would not diplay the duplicated rows

 

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.