Forum Discussion
Solved
If Condition
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 ) ...
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"
)
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"
)