If statement in load

[#1]

Morning all

Can someone assist please.

I have the following statement in my load:

LOAD

IF ([EndOfMonth]<[Today],'Overdue',

IF ([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH'))AS Status

Which is working fine.

However, I would like to adapt this to say that if it does not match either of these IF statement then

to put the text 'Overdue'

Thank you

[sunny_talwar · Accepted solution]

May be this:

LOAD

If([EndOfMonth]<[Today],'Overdue',

If([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH', 'OverDue')) as Status

[kkkumar82]

I think you already have "overdue"

but anyhow

IF ([EndOfMonth]<[Today],'Overdue',

IF ([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH'.'Overdue'))AS Status

[sunny_talwar]

Or may be this:

LOAD

If([EndOfMonth]<=[EndOfCurrentMonth], 'FALLING DUE BY END OF MONTH', 'OverDue') as Status

[#5]

Thanks Sunny

For the different ways to achieve this.