PLEASE HELP: How to achieve the following result?

[tarunIMDG]

I have a tabular data which I need to group based on vintages and payment-vintages .. see the desired result column in red

[Felipe_Ribeir0 · Accepted solution]

Hi @tarunIMDG 

You can use this formula

datetimediff(datetimeparse([payment-vtg], "%Y-%m-01"), datetimeparse([vintage], "%Y-%m-01"), "months")