Solved: Re: Convert the below dax to m query

Antmkjr · ‎04-25-2021

how to convert the below dax to m query.

Flag PH =

IF (

NOT (

ISBLANK ( 'Table A'[Amount on Hold] )

),

IF (

ROUND( ('Table A'[AP ] + 'Table A'[Amount on Hold]),1) = 0,

"Payments on Hold"

)

I am fairly new to m query, can some one help with this.

Fowmy · ‎04-25-2021

@Antmkjr

You try the following formula as a new custom column in PQ:

=if [Amount on Hold] <> null and Number.Round([Amount on Hold]+[AP],1) = 0 then  "Payments on Hold" else null

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎04-25-2021

@Antmkjr

You try the following formula as a new custom column in PQ:

=if [Amount on Hold] <> null and Number.Round([Amount on Hold]+[AP],1) = 0 then  "Payments on Hold" else null

Did I answer your question? Mark my post as a solution! and hit thumbs up

Convert the below dax to m query