If Condition

[bhelou]

Hello , 
please if you can help me with this measure :

i have 5 conditions need to make a remark column for each single one : 
 

1- if AP_Payments = Blank  , give me a remark ( Not Paid ) 

2- if AP_Lines = 0 or blank  , give me ( Voided )

3- ap_lines -sar_payments > 0 , give me partially paid   (* note , in ap _payments should be more than 0 to calculate the remaining )

4 - same as # 3 , as overpaid but need to make the remark for it as paid also

5 - if ap_lines = ap_payments , give me( fully paid )

Attached Image

Thank you

[bhelou]

Thank you , worked perfect 

[amitchandak · Accepted solution]

@bhelou , You can create a new column like

Switch( True() ,

Isblank([AP_Payments]),  "Not Paid",

coalesce([AP_Line],0) =0 , "Voided",

// Add others

[ap_lines] = [ap_payment] , "Fully Paid"

)