calculate Month over the Limit

I want to calculate which month the value will over the limit.

The data source is:

The desired result “Month Over Limit” will be:

In Excel, I can do calculation like below to get the result:

How can I get the Month Over Limit in Alteryx?

Accepted answers

you can use the Formula tool to solve your problem - it's a bit of DateTime calculation. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

you can use the Formula tool to solve your problem - it's a bit of DateTime calculation. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

Thanks, Roland.

Sorry, I cannot not open your attached file. The Alteryx version I’m using is Alteryx Designer 2019.3

cannot open.PNG