I have this formula that captures the difference between two seperate dimension dates. How can I have all numbers after 12 be grouped into 1 month number. So 1-11 and then 12+?
datediff('month',datetrunc('month',[start month]),datetrunc('month',[paid month]))+ 1
One possible calculation would be:
if [field]>12 then "Over 1 year" else "First Year" End