Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert the below dax to m query

https://drive.google.com/file/d/1nv4wk6uv8ZfN45kJzlyaBCKu5kYbKmtl/view?usp=sharing

 

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.

Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    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

     

     

1 Reply

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    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