Variance from categories

Hello,

i am struggling to find the good formula to calculate a variance. I have a table with categories which are quarters but in text format not in date type. And I have a measure in percentage in an other table. I don't arrived to calculate the variation between the categories .

What should I do use?