https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Complex-DAX-Formula/m-p/3121080#M156755 <P>Hi All,</P><P>&nbsp;</P><P>Need your help in creating DAX measure for a complex scenario. Please find data as below.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>eglEnt-EntityID</TD><TD>End Effective Date</TD><TD>GrossReturn</TD></TR><TR><TD>CVIAGEQC</TD><TD>1/31/2022</TD><TD>-4.373229085</TD></TR><TR><TD>CVIAGEQC</TD><TD>2/28/2022</TD><TD>-1.376539353</TD></TR><TR><TD>CVIAGEQC</TD><TD>3/31/2022</TD><TD>-1.475548259</TD></TR><TR><TD>CVIAGEQC</TD><TD>4/30/2022</TD><TD>-6.638796952</TD></TR><TR><TD>CVIAGEQC</TD><TD>5/31/2022</TD><TD>0.55902424</TD></TR><TR><TD>CVIAGEQC</TD><TD>6/30/2022</TD><TD>-4.625465057</TD></TR><TR><TD>CVIAGEQC</TD><TD>7/31/2022</TD><TD>0.451332526</TD></TR><TR><TD>CVIAGEQC</TD><TD>8/31/2022</TD><TD>-1.650291464</TD></TR><TR><TD>CVIAGEQC</TD><TD>9/30/2022</TD><TD>-10.24389111</TD></TR><TR><TD>CVIAGEQC</TD><TD>10/31/2022</TD><TD>-2.514744465</TD></TR><TR><TD>CVIAGEQC</TD><TD>11/30/2022</TD><TD>12.46723644</TD></TR><TR><TD>CVIAGEQC</TD><TD>12/31/2022</TD><TD>0.04435882</TD></TR><TR><TD>CVIAGEQC</TD><TD>1/31/2023</TD><TD>7.708244223</TD></TR><TR><TD>CV13SMEP</TD><TD>10/31/2021</TD><TD>2.074472323</TD></TR><TR><TD>CV13SMEP</TD><TD>11/30/2021</TD><TD>-3.256589276</TD></TR><TR><TD>CV13SMEP</TD><TD>12/31/2021</TD><TD>1.769018998</TD></TR><TR><TD>CV13SMEP</TD><TD>1/31/2022</TD><TD>-6.868652896</TD></TR><TR><TD>CV13SMEP</TD><TD>2/28/2022</TD><TD>4.845474913</TD></TR><TR><TD>CV13SMEP</TD><TD>3/31/2022</TD><TD>-1.514637116</TD></TR><TR><TD>CV13SMEP</TD><TD>4/30/2022</TD><TD>0.651104627</TD></TR><TR><TD>CV13SMEP</TD><TD>5/31/2022</TD><TD>-3.72439535</TD></TR><TR><TD>CV13SMEP</TD><TD>6/30/2022</TD><TD>-7.78854253</TD></TR><TR><TD>CV13SMEP</TD><TD>7/31/2022</TD><TD>2.90686213</TD></TR><TR><TD>CV13SMEP</TD><TD>8/31/2022</TD><TD>1.827081104</TD></TR><TR><TD>CV13SMEP</TD><TD>9/30/2022</TD><TD>-5.760868735</TD></TR><TR><TD>CV13SMEP</TD><TD>10/31/2022</TD><TD>2.640674076</TD></TR><TR><TD>CV13SMEP</TD><TD>11/30/2022</TD><TD>3.016640222</TD></TR><TR><TD>CV13SMEP</TD><TD>12/31/2022</TD><TD>2.723576162</TD></TR><TR><TD>CV13SMEP</TD><TD>1/31/2023</TD><TD>2.730720733</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Need to calculate E column as shown in the below screenshot for the Entity ID "CV13SMEP"</P><P>&nbsp;</P><P><img /></P><P>Similarly Expected result for Entity ID "CVIAGEQC"</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 09 Mar 2023 09:50:57 GMT Anonymous 2023-03-09T09:50:57Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Complex-DAX-Formula/m-p/3121080#M156755 <P>Hi All,</P><P>&nbsp;</P><P>Need your help in creating DAX measure for a complex scenario. Please find data as below.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>eglEnt-EntityID</TD><TD>End Effective Date</TD><TD>GrossReturn</TD></TR><TR><TD>CVIAGEQC</TD><TD>1/31/2022</TD><TD>-4.373229085</TD></TR><TR><TD>CVIAGEQC</TD><TD>2/28/2022</TD><TD>-1.376539353</TD></TR><TR><TD>CVIAGEQC</TD><TD>3/31/2022</TD><TD>-1.475548259</TD></TR><TR><TD>CVIAGEQC</TD><TD>4/30/2022</TD><TD>-6.638796952</TD></TR><TR><TD>CVIAGEQC</TD><TD>5/31/2022</TD><TD>0.55902424</TD></TR><TR><TD>CVIAGEQC</TD><TD>6/30/2022</TD><TD>-4.625465057</TD></TR><TR><TD>CVIAGEQC</TD><TD>7/31/2022</TD><TD>0.451332526</TD></TR><TR><TD>CVIAGEQC</TD><TD>8/31/2022</TD><TD>-1.650291464</TD></TR><TR><TD>CVIAGEQC</TD><TD>9/30/2022</TD><TD>-10.24389111</TD></TR><TR><TD>CVIAGEQC</TD><TD>10/31/2022</TD><TD>-2.514744465</TD></TR><TR><TD>CVIAGEQC</TD><TD>11/30/2022</TD><TD>12.46723644</TD></TR><TR><TD>CVIAGEQC</TD><TD>12/31/2022</TD><TD>0.04435882</TD></TR><TR><TD>CVIAGEQC</TD><TD>1/31/2023</TD><TD>7.708244223</TD></TR><TR><TD>CV13SMEP</TD><TD>10/31/2021</TD><TD>2.074472323</TD></TR><TR><TD>CV13SMEP</TD><TD>11/30/2021</TD><TD>-3.256589276</TD></TR><TR><TD>CV13SMEP</TD><TD>12/31/2021</TD><TD>1.769018998</TD></TR><TR><TD>CV13SMEP</TD><TD>1/31/2022</TD><TD>-6.868652896</TD></TR><TR><TD>CV13SMEP</TD><TD>2/28/2022</TD><TD>4.845474913</TD></TR><TR><TD>CV13SMEP</TD><TD>3/31/2022</TD><TD>-1.514637116</TD></TR><TR><TD>CV13SMEP</TD><TD>4/30/2022</TD><TD>0.651104627</TD></TR><TR><TD>CV13SMEP</TD><TD>5/31/2022</TD><TD>-3.72439535</TD></TR><TR><TD>CV13SMEP</TD><TD>6/30/2022</TD><TD>-7.78854253</TD></TR><TR><TD>CV13SMEP</TD><TD>7/31/2022</TD><TD>2.90686213</TD></TR><TR><TD>CV13SMEP</TD><TD>8/31/2022</TD><TD>1.827081104</TD></TR><TR><TD>CV13SMEP</TD><TD>9/30/2022</TD><TD>-5.760868735</TD></TR><TR><TD>CV13SMEP</TD><TD>10/31/2022</TD><TD>2.640674076</TD></TR><TR><TD>CV13SMEP</TD><TD>11/30/2022</TD><TD>3.016640222</TD></TR><TR><TD>CV13SMEP</TD><TD>12/31/2022</TD><TD>2.723576162</TD></TR><TR><TD>CV13SMEP</TD><TD>1/31/2023</TD><TD>2.730720733</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Need to calculate E column as shown in the below screenshot for the Entity ID "CV13SMEP"</P><P>&nbsp;</P><P><img /></P><P>Similarly Expected result for Entity ID "CVIAGEQC"</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 09 Mar 2023 09:50:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Creating-Complex-DAX-Formula/m-p/3121080#M156755 Anonymous 2023-03-09T09:50:57Z