Forum Discussion

MP-iCONN's avatar
MP-iCONN
Icon for Resolver I rankResolver I
3 years ago
Solved

Custom Column to show Text and Column Value together based on Condition

I have an account statement I want to send out to our customers.    This will consist of Invoice Number, PO #, Invoice Date, Due Date, then a calculated column on how many days Past Due, then final...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    Something like the following should work...
    if [Past Due] > 0 then [Past Due] else "Due in " & Text.From([Past Due]*-1) & " days"

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

Something like the following should work...
if [Past Due] > 0 then [Past Due] else "Due in " & Text.From([Past Due]*-1) & " days"

MP-iCONN's avatar
MP-iCONN
Icon for Resolver I rankResolver I
3 years ago

That was perfect!   Thank you very very much!