Forum Discussion

geetika3110's avatar
geetika3110
Frequent Visitor
4 years ago
Solved

Need Help - Divide based on multiple criteria

Hi All, Hope you are well.  I am new to power BI and trying to create a report and need your support with DAX measure.   Below is a sample table where i have MWD spent by month. I am looking for ...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi geetika3110 ,

    According to your description, here's my solution.

    To be divided by =
IF (
    MAX ( 'FTE'[Month] ) IN { "Jan", "April", "July", "October" },
    19.125,
    15.3
)

    FTE = DIVIDE ( SUM ( 'FTE'[MWD] ), 'FTE'[To be divided by] )

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi geetika3110 ,

According to your description, here's my solution.

To be divided by =
IF (
    MAX ( 'FTE'[Month] ) IN { "Jan", "April", "July", "October" },
    19.125,
    15.3
)

FTE = DIVIDE ( SUM ( 'FTE'[MWD] ), 'FTE'[To be divided by] )

Get the result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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