topic Gift frequency increase after I contacted donor in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3444958#M131037 <P>Hi ,</P><P>I am trying to&nbsp; find second gift rate after I contacted donor&nbsp; . I want to analyse how my engagement with donor is encouraging donor to make second gift . I am looking at call dates and gift dates to find the gift frequency. I have three tables to get these information . Could you kindly assist .&nbsp;</P><P>Sample data</P><P>Table 1 Action look up(I have added action in RE after I make call)</P><TABLE><TBODY><TR><TD>Constituent ID</TD><TD>Action Import ID</TD><TD>Call Type</TD><TD>Call Date</TD><TD>Status&nbsp;</TD></TR><TR><TD>1111</TD><TD>00001-504-0003373693</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>2222</TD><TD>00001-504-0003373697</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>3333</TD><TD>00001-504-0003373700</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>4444</TD><TD>00001-504-0003374645</TD><TD>Welcome Call</TD><TD>18/04/2023</TD><TD>Completed</TD></TR><TR><TD>5555</TD><TD>00001-504-0003417401</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>6666</TD><TD>00001-504-0003417367</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>7777</TD><TD>00001-504-0003417368</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>8888</TD><TD>00001-504-0002911815</TD><TD>Welcome Call</TD><TD>7/10/2022</TD><TD>Completed</TD></TR><TR><TD>9999</TD><TD>00001-504-0002911967</TD><TD>Welcome Call</TD><TD>7/10/2022</TD><TD>Completed</TD></TR></TBODY></TABLE><P>Table 2</P><P>Gift Look Up (Gifts made by donor till date)</P><TABLE><TBODY><TR><TD>Constituent ID</TD><TD>Gift Import ID</TD><TD>Gift Date</TD><TD>Gift Amount</TD></TR><TR><TD>1111</TD><TD>00001-545-0000</TD><TD>14/12/2020</TD><TD>$1,000.00</TD></TR><TR><TD>1111</TD><TD>00001-545-0001</TD><TD>3/12/2021</TD><TD>$1,000.00</TD></TR><TR><TD>2222</TD><TD>00001-545-0002</TD><TD>17/05/2022</TD><TD>$1,000.00</TD></TR><TR><TD>2222</TD><TD>00001-545-0003</TD><TD>13/07/2022</TD><TD>$4,000.00</TD></TR><TR><TD>3333</TD><TD>00001-545-0004</TD><TD>29/11/2022</TD><TD>$100.00</TD></TR><TR><TD>3333</TD><TD>00001-545-0005</TD><TD>5/5/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0006</TD><TD>15/06/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0007</TD><TD>15/05/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0008</TD><TD>20/07/2022</TD><TD>$100.00</TD></TR><TR><TD>5555</TD><TD>00001-545-0009</TD><TD>23/05/2016</TD><TD>$30.00</TD></TR><TR><TD>6666</TD><TD>00001-545-0010</TD><TD>25/11/2021</TD><TD>$200.00</TD></TR><TR><TD>6666</TD><TD>00001-545-0011</TD><TD>15/07/2023</TD><TD>$10.00</TD></TR><TR><TD>7777</TD><TD>00001-545-0012</TD><TD>15/08/2023</TD><TD>$10.00</TD></TR><TR><TD>8888</TD><TD>00001-545-0013</TD><TD>19/05/2016</TD><TD>$100.00</TD></TR><TR><TD>9999</TD><TD>00001-545-0014</TD><TD>31/01/2023</TD><TD>$50.00</TD></TR><TR><TD>9999</TD><TD>00001-545-0015</TD><TD>16/05/2016</TD><TD>$20.00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table 3 Donor Look Up</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Constituent ID</TD><TD>First Name</TD><TD>Surname</TD></TR><TR><TD>1111</TD><TD>Andrew</TD><TD>xxxx</TD></TR><TR><TD>2222</TD><TD>Keith</TD><TD>xxxx</TD></TR><TR><TD>3333</TD><TD>John</TD><TD>xxxx</TD></TR><TR><TD>4444</TD><TD>Lorraine</TD><TD>xxxx</TD></TR><TR><TD>5555</TD><TD>Heili</TD><TD>xxxx</TD></TR><TR><TD>6666</TD><TD>Gerry</TD><TD>xxxx</TD></TR><TR><TD>7777</TD><TD>Carmen</TD><TD>xxxx</TD></TR><TR><TD>8888</TD><TD>Melissa</TD><TD>xxxx</TD></TR><TR><TD>9999</TD><TD>Henry</TD><TD>xxxx</TD></TR></TBODY></TABLE> Sun, 24 Sep 2023 23:21:39 GMT roseyBP 2023-09-24T23:21:39Z Gift frequency increase after I contacted donor https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3444958#M131037 <P>Hi ,</P><P>I am trying to&nbsp; find second gift rate after I contacted donor&nbsp; . I want to analyse how my engagement with donor is encouraging donor to make second gift . I am looking at call dates and gift dates to find the gift frequency. I have three tables to get these information . Could you kindly assist .&nbsp;</P><P>Sample data</P><P>Table 1 Action look up(I have added action in RE after I make call)</P><TABLE><TBODY><TR><TD>Constituent ID</TD><TD>Action Import ID</TD><TD>Call Type</TD><TD>Call Date</TD><TD>Status&nbsp;</TD></TR><TR><TD>1111</TD><TD>00001-504-0003373693</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>2222</TD><TD>00001-504-0003373697</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>3333</TD><TD>00001-504-0003373700</TD><TD>Welcome Call</TD><TD>14/04/2023</TD><TD>Completed</TD></TR><TR><TD>4444</TD><TD>00001-504-0003374645</TD><TD>Welcome Call</TD><TD>18/04/2023</TD><TD>Completed</TD></TR><TR><TD>5555</TD><TD>00001-504-0003417401</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>6666</TD><TD>00001-504-0003417367</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>7777</TD><TD>00001-504-0003417368</TD><TD>Welcome Call</TD><TD>11/5/2023</TD><TD>Completed</TD></TR><TR><TD>8888</TD><TD>00001-504-0002911815</TD><TD>Welcome Call</TD><TD>7/10/2022</TD><TD>Completed</TD></TR><TR><TD>9999</TD><TD>00001-504-0002911967</TD><TD>Welcome Call</TD><TD>7/10/2022</TD><TD>Completed</TD></TR></TBODY></TABLE><P>Table 2</P><P>Gift Look Up (Gifts made by donor till date)</P><TABLE><TBODY><TR><TD>Constituent ID</TD><TD>Gift Import ID</TD><TD>Gift Date</TD><TD>Gift Amount</TD></TR><TR><TD>1111</TD><TD>00001-545-0000</TD><TD>14/12/2020</TD><TD>$1,000.00</TD></TR><TR><TD>1111</TD><TD>00001-545-0001</TD><TD>3/12/2021</TD><TD>$1,000.00</TD></TR><TR><TD>2222</TD><TD>00001-545-0002</TD><TD>17/05/2022</TD><TD>$1,000.00</TD></TR><TR><TD>2222</TD><TD>00001-545-0003</TD><TD>13/07/2022</TD><TD>$4,000.00</TD></TR><TR><TD>3333</TD><TD>00001-545-0004</TD><TD>29/11/2022</TD><TD>$100.00</TD></TR><TR><TD>3333</TD><TD>00001-545-0005</TD><TD>5/5/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0006</TD><TD>15/06/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0007</TD><TD>15/05/2023</TD><TD>$10.00</TD></TR><TR><TD>4444</TD><TD>00001-545-0008</TD><TD>20/07/2022</TD><TD>$100.00</TD></TR><TR><TD>5555</TD><TD>00001-545-0009</TD><TD>23/05/2016</TD><TD>$30.00</TD></TR><TR><TD>6666</TD><TD>00001-545-0010</TD><TD>25/11/2021</TD><TD>$200.00</TD></TR><TR><TD>6666</TD><TD>00001-545-0011</TD><TD>15/07/2023</TD><TD>$10.00</TD></TR><TR><TD>7777</TD><TD>00001-545-0012</TD><TD>15/08/2023</TD><TD>$10.00</TD></TR><TR><TD>8888</TD><TD>00001-545-0013</TD><TD>19/05/2016</TD><TD>$100.00</TD></TR><TR><TD>9999</TD><TD>00001-545-0014</TD><TD>31/01/2023</TD><TD>$50.00</TD></TR><TR><TD>9999</TD><TD>00001-545-0015</TD><TD>16/05/2016</TD><TD>$20.00</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Table 3 Donor Look Up</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Constituent ID</TD><TD>First Name</TD><TD>Surname</TD></TR><TR><TD>1111</TD><TD>Andrew</TD><TD>xxxx</TD></TR><TR><TD>2222</TD><TD>Keith</TD><TD>xxxx</TD></TR><TR><TD>3333</TD><TD>John</TD><TD>xxxx</TD></TR><TR><TD>4444</TD><TD>Lorraine</TD><TD>xxxx</TD></TR><TR><TD>5555</TD><TD>Heili</TD><TD>xxxx</TD></TR><TR><TD>6666</TD><TD>Gerry</TD><TD>xxxx</TD></TR><TR><TD>7777</TD><TD>Carmen</TD><TD>xxxx</TD></TR><TR><TD>8888</TD><TD>Melissa</TD><TD>xxxx</TD></TR><TR><TD>9999</TD><TD>Henry</TD><TD>xxxx</TD></TR></TBODY></TABLE> Sun, 24 Sep 2023 23:21:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3444958#M131037 roseyBP 2023-09-24T23:21:39Z Re: Gift frequency increase after I contacted donor https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3445313#M131068 <P>You might require the following dax measure</P><P><SPAN>SecondGiftRate = VAR FirstGiftDate = MIN(Gift[Gift Date]) RETURN DIVIDE( COUNTROWS(FILTER(Gift, Gift[Gift Date] &gt; FirstGiftDate)), COUNTROWS(DISTINCT(Action[Call Date])), 0 )</SPAN></P> Mon, 25 Sep 2023 07:09:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3445313#M131068 nirali_arora 2023-09-25T07:09:10Z Re: Gift frequency increase after I contacted donor https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3445724#M131091 <P>Hi&nbsp;@&nbsp;<SPAN class=""><A href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/619046" target="_self"><SPAN class="">roseyBP,</SPAN></A></SPAN></P><P>&nbsp;</P><P><SPAN class=""><SPAN class="">Your calls have increased the frequency of the donations as shown below, even though the amounts are nominal.&nbsp;</SPAN></SPAN></P><DIV class=""><img /><P>I attach the pbix file below:</P><P><A href="https://1drv.ms/u/s!AlqFfzVTqicpnjlutoUgkE3Lep1m?e=NHF1Fw" target="_blank" rel="noopener">Gift Donation.pbix</A></P></DIV> Mon, 25 Sep 2023 10:32:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3445724#M131091 DataNinja777 2023-09-25T10:32:35Z Re: Gift frequency increase after I contacted donor https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3446812#M131163 <P>Thank You so much&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Mon, 25 Sep 2023 23:11:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3446812#M131163 roseyBP 2023-09-25T23:11:26Z Re: Gift frequency increase after I contacted donor https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3446813#M131164 <P>Thank You so much&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Mon, 25 Sep 2023 23:11:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Gift-frequency-increase-after-I-contacted-donor/m-p/3446813#M131164 roseyBP 2023-09-25T23:11:45Z