Forum Discussion

chuber48's avatar
chuber48
Frequent Visitor
8 years ago

Powerbi PPM calculation

I am trying to calculate Parts per million (PPM) using two different tables   Table 1 RMA contains the fields reject_quantity, reject_type, and reject_date.   Table 2 SHIPPED contains the fields ...
v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
8 years ago

Hi chuber48,

I could not figure out how could you calculate the "PPM", could you please offer me the formula? And if you want to combine two table data, you could refer to below steps:

Smple data:

Create a calender table and create relationship

New table:

Calendar = CALENDAR("2018,1,1","2018,12,31")

Create a calculated column in calendar table and you could see the result.

Column = RELATED(RMA[reject_quantity])&RELATED(SHIPPED[quantity])

 

If I misunderstood you, please let me know as soon as possible.

 

Regards,

Daniel He

  • chuber48's avatar
    chuber48
    Frequent Visitor
    8 years ago

    Daniel He,

     

    Thank you for the reply.  I am trying to implement what you suggested.  I am having a problem when I try to use the related command in the calendar table.  I believe it is because of the type of relationship created.  It looks like yours is 1 to 1 where mine is 1 to many.  For example we may have multiple rejects per calendar date and multiple shipments per day.  Below is a screen shot of the relationship screen