IF and Multiply

[AllanBerces]

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

[lbendlin · Accepted solution]

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)

[AllanBerces]

Hi @lbendlin thank you very much for the reply