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 ...
AndreDinis's avatar
AndreDinis
Frequent Visitor
7 years ago

Hello chuber48 

 

Did you manage to solve this problem?

 

I have the same problem as you do

 

Than you

André Dinis

  • chuber48's avatar
    chuber48
    Frequent Visitor
    7 years ago

    First I created a table that showed quarters as below.  I did this manually but know now that it could be generated.

     

    This contained the columns as shown:

     

    Year    Quarter    YearQ   Externals   Shipped    External PPS   External PPM

     

    Year and Quarter can be either generated with a calendar function or entered manually:

     

    2017       1           20171

     

    Externals are pulled from our Quality database (RMA):

     

    Externals = CALCULATE(SUM(RMA[Quantity]),FILTER(rma,RMA[YearQ]=Quarters[YearQ]),Filter(rma,RMA[REJECT_CATEGORY]="External"))

     

    Shipped comes from our invoiced reports (SIRPT):

     

    Shipped = CALCULATE(sum(SIRPT[Qty shipped]),filter(SIRPT,SIRPT[YearQ]=Quarters[YearQ]))

     

    External pps is calculated as:

     

    External pps = DIVIDE(Quarters[Externals],Quarters[Shipped])

     

    Finally External PPM  is calculated as:

     

    External PPM = format(Quarters[External pps]*1000000,"###,###.00")

     

    These last 2 steps could probably be combined, It has been a while since I completed this.  

     

    If there other ways to do this it would be great to hear about them.  You could use any date format that you want, weekly etc.

     

    Sorry for the format of this email I did know how to get the great graphics that everyone else does.

     

    Thank You