Forum Discussion

sushil353's avatar
sushil353
Regular Visitor
8 years ago
Solved

How to show customer having pending payment

HI All,   I have a data set where i do have customer name, Total Sales and Payment.    I want to create a table where i want to show the details of the customer having pending payment.   Pendin...
Need Help
  • abhi9255's avatar
    abhi9255
    8 years ago

    You can try to create the measure to achieve that result

     

    for example : 

    Pending payment =

    var pending_payment = sum([Total Sales]) - sum([Payment]) 

    return if (pending_payment >0, pending_payment ,0)

  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi sushil353,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale

abhi9255's avatar
abhi9255
Icon for Advocate II rankAdvocate II
8 years ago

You can try to create the measure to achieve that result

 

for example : 

Pending payment =

var pending_payment = sum([Total Sales]) - sum([Payment]) 

return if (pending_payment >0, pending_payment ,0)