Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyIF 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...
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)
lbendlin
Super User
Super UserPlease 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)
AllanBercesHi lbendlin thank you very much for the reply