Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
11 months ago
Solved

IF and Multiply

Hi good morning can anyone help me correct my dax on my PQ custom column. what i required is IF the column %RO s blank then i want the value of column Hours but if not blank multiply column hours and %RO.

 

if[#"% RO"] = blank(),[hours] else [hours] *[#"% RO"]

 

Thank you

Need Help
  • lbendlin's avatar
    lbendlin
    11 months ago

    Please indicate if you want Power Query or DAX. You cannot mix them.

     

    Power Query:

     

    if [#"% RO"] = null then [hours] else [hours] *[#"% RO"]

     

    DAX:

    IF( ISBLANK([% RO]),[hours],[hours] *[% RO])

     

    Or simplified

    [hours]*COALESCE([% RO],1)

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    11 months ago

    Please indicate if you want Power Query or DAX. You cannot mix them.

     

    Power Query:

     

    if [#"% RO"] = null then [hours] else [hours] *[#"% RO"]

     

    DAX:

    IF( ISBLANK([% RO]),[hours],[hours] *[% RO])

     

    Or simplified

    [hours]*COALESCE([% RO],1)