Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Working Days Divided by two for Part Time Employees

Good Day,

I am needing to adjust my Dax formula to divide by two when the employee is Kennedee Lantis. Can someone lend me a hand?

Per Day Average = CALCULATE(Audit[SUM pro/job Audits & Entries]/MAX('Working Days'[Working Days]) + 0)

 

Many thanks,

 

Lydia

average
DAX
divide
Part Time
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    Per Day Average =
VAR Result =
    CALCULATE (
        DIVIDE ( [SUM pro/job Audits & Entries], MAX ( 'Working Days'[Working Days] ) ) + 0
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Name] ) = "Kennedee Lantis",
        DIVIDE ( Result, 2 ),
        Result
    )

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous 
    Please try

    Per Day Average =
VAR Result =
    CALCULATE (
        DIVIDE ( [SUM pro/job Audits & Entries], MAX ( 'Working Days'[Working Days] ) ) + 0
    )
RETURN
    IF (
        SELECTEDVALUE ( 'Table'[Name] ) = "Kennedee Lantis",
        DIVIDE ( Result, 2 ),
        Result
    )