https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496451#M133952 <P>I tried various but no one works.&nbsp;</P> Wed, 25 Oct 2023 13:03:43 GMT Capitano_Fl99 2023-10-25T13:03:43Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496265#M133943 <P>Hello,</P><P>&nbsp;</P><P>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 .</P><P>&nbsp;</P><P>What should I do use?</P> Wed, 25 Oct 2023 11:43:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496265#M133943 Capitano_Fl99 2023-10-25T11:43:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496379#M133948 <P>Try using a different calculation</P> Wed, 25 Oct 2023 12:38:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496379#M133948 EylesIT 2023-10-25T12:38:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496451#M133952 <P>I tried various but no one works.&nbsp;</P> Wed, 25 Oct 2023 13:03:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Variance-from-categories/m-p/3496451#M133952 Capitano_Fl99 2023-10-25T13:03:43Z