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

     

Anonymous's avatar
Anonymous
Not applicable
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