Forum Discussion

mikesdunbar's avatar
mikesdunbar
Icon for Helper I rankHelper I
1 year ago
Solved

Calculate difference using minimum values

I'm trying to establish a value for whether someone underused or overused hours allocated to a project. For instance, Tom Smith wasn't forcasted to work on 3/4/2024, so he was over $80.40. On 3/19 Ni...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi mikesdunbar ,
    In Power BI Desktop, you can create calculated column to achieve this

    Actual Rate = 
CALCULATE(
    MIN('Table'[Rate]),
    ALLEXCEPT(
        'Table',    
        'Table'[User]
    )
)
    Billing Delt Rate = ('Table'[Forceasted hours] - 'Table'[Actual hours]) * 'Table'[Actual Rate]

    Fina output

     

    Best regards,
    Albert He

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

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

some would say exorbitant, others would recognize a buffer overrun (2 to the Power of 31 minus 1, divided by 10 for some reason).  Might want to replace that value with null.