https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula-to-be-able-to-reflect-data-on-the-table-base-on-the/m-p/1913733#M41398 <P>Hi guys,</P><P>I need your help on coming up with a formula to be able to reflect the "Actions to be done" based on the value on the table.</P><P><img /></P><P>The matrix is as follows:&nbsp;</P><P>1 Yellow = Meeting<BR />2 Yellow consecutive months = Issue poor performance<BR />3 Yellow&nbsp; for consecutive months or 1 Red = NTE<BR />2 Red for consecutive months = Conduct counseling<BR />3 Red for consecutive month = Delisting</P><P>&nbsp;</P><P>The table result should look a little like this.</P><P><img /></P><P>&nbsp;</P><P>Your help will be greatly appreciated&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 22 Jun 2021 05:56:15 GMT Ky_04 2021-06-22T05:56:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula-to-be-able-to-reflect-data-on-the-table-base-on-the/m-p/1913733#M41398 <P>Hi guys,</P><P>I need your help on coming up with a formula to be able to reflect the "Actions to be done" based on the value on the table.</P><P><img /></P><P>The matrix is as follows:&nbsp;</P><P>1 Yellow = Meeting<BR />2 Yellow consecutive months = Issue poor performance<BR />3 Yellow&nbsp; for consecutive months or 1 Red = NTE<BR />2 Red for consecutive months = Conduct counseling<BR />3 Red for consecutive month = Delisting</P><P>&nbsp;</P><P>The table result should look a little like this.</P><P><img /></P><P>&nbsp;</P><P>Your help will be greatly appreciated&nbsp;<span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 22 Jun 2021 05:56:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-formula-to-be-able-to-reflect-data-on-the-table-base-on-the/m-p/1913733#M41398 Ky_04 2021-06-22T05:56:15Z