Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Multiple IF Condition

Hi and good day to all, Can someone help me on my new calculated column. I have a table with column scope, % materials, Budgeted hrs, Treade and Hour Equevalent. Basically what i want to achieved is...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi AllanBerces  - You can create the calculated column for "Hour Equivalent" in Power BI using DAX.

    Hour Equivalent =
    IF(
        Heoutput[Trade] = "Scaff",
        Heoutput[Budgeted hrs],
        IF(
            Heoutput[% Materials] = BLANK() || Heoutput[% Materials] = "Blank",
            Heoutput[Budgeted hrs],
            Heoutput[% Materials] * Heoutput[Budgeted hrs]
        )
    )

     

     

    Please check and i hope it works at your end.

     

     

DataNinja777's avatar
DataNinja777
Super User
1 year ago

Hi AllanBerces ,

 

Your requirement can be easily handled with a calculated column in Power BI using the DAX formula below similar to the Excel example you produced:

Hour Equivalent =
SWITCH(
    TRUE(),
    'YourTable'[Trade] = "Scaff", 'YourTable'[Budgeted hrs],
    ISBLANK('YourTable'[% Materials]), 'YourTable'[Budgeted hrs],
    'YourTable'[% Materials] * 'YourTable'[Budgeted hrs]
)

 

Best regards,