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.

     

     

rajendraongole1's avatar
rajendraongole1
Super User
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.