https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-measure-last-year-and-add-status/m-p/3197135#M116112 <P>Hello,</P><P>I need to compare an amount like Revenue the selected year N with the previous year related N-1 and add a status with this condition if Revenue N = 0 and Revenue N-1 &gt;0 then "inactive" for a main fact table and for 3 Others fact table, then I need to Display the result on a single Matrix.</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nb active |&nbsp; Nb inactive | Nb New</P><P>Year N.&nbsp; &nbsp; |&nbsp;</P><P>Year N-1 |&nbsp;</P><P>What is the best technique for reach this result ?</P><P>Please could you help me ?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Apr 2023 04:53:08 GMT PBI_dv 2023-04-20T04:53:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-measure-last-year-and-add-status/m-p/3197135#M116112 <P>Hello,</P><P>I need to compare an amount like Revenue the selected year N with the previous year related N-1 and add a status with this condition if Revenue N = 0 and Revenue N-1 &gt;0 then "inactive" for a main fact table and for 3 Others fact table, then I need to Display the result on a single Matrix.</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nb active |&nbsp; Nb inactive | Nb New</P><P>Year N.&nbsp; &nbsp; |&nbsp;</P><P>Year N-1 |&nbsp;</P><P>What is the best technique for reach this result ?</P><P>Please could you help me ?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 20 Apr 2023 04:53:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Compare-measure-last-year-and-add-status/m-p/3197135#M116112 PBI_dv 2023-04-20T04:53:08Z