topic Re: Daily Amount in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261749#M168908 <P>please find it below. Thank you</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>AccountNumber</TD><TD>Sum of AccountSuffix</TD><TD>Sum of Amount</TD><TD>CustomerName</TD><TD>TranDate</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>118,4210526</TD><TD>Alper</TD><TD>30.09.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-112,5921053</TD><TD>Alper</TD><TD>01.10.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-5,828947368</TD><TD>Alper</TD><TD>02.11.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>6,389473684</TD><TD>Alper</TD><TD>04.11.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-6,389473684</TD><TD>Alper</TD><TD>01.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>12,17039474</TD><TD>Alper</TD><TD>03.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-6,557894737</TD><TD>Alper</TD><TD>30.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>65,78947368</TD><TD>Alper</TD><TD>05.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>06.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-193,1638158</TD><TD>Alper</TD><TD>12.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>-9,210526316</TD><TD>Alper</TD><TD>17.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,341315789</TD><TD>Alper</TD><TD>23.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>2,894736842</TD><TD>Alper</TD><TD>25.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-2,647368421</TD><TD>Alper</TD><TD>26.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>0,657894737</TD><TD>Alper</TD><TD>03.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-1,170526316</TD><TD>Alper</TD><TD>17.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>22.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>11.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>14.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>19.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>20.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,972894737</TD><TD>Alper</TD><TD>21.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>7,894736842</TD><TD>Alper</TD><TD>27.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-5,778684211</TD><TD>Alper</TD><TD>02.05.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-3,088947368</TD><TD>Alper</TD><TD>01.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0</TD><TD>Alper</TD><TD>06.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>07.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>2,718421053</TD><TD>Alper</TD><TD>13.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-2,718421053</TD><TD>Alper</TD><TD>01.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>171,0526316</TD><TD>Alper</TD><TD>07.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>08.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>-301,2509211</TD><TD>Alper</TD><TD>12.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-1,380657895</TD><TD>Alper</TD><TD>01.08.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0,727894737</TD><TD>Alper</TD><TD>03.08.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,727894737</TD><TD>Alper</TD><TD>01.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>06.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>07.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>11</TD><TD>1,051052632</TD><TD>Alper</TD><TD>08.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-1,051052632</TD><TD>Alper</TD><TD>04.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0,923289474</TD><TD>Alper</TD><TD>07.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-0,923289474</TD><TD>Alper</TD><TD>26.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>07.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>2,877105263</TD><TD>Alper</TD><TD>08.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-1,315789474</TD><TD>Alper</TD><TD>10.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>0,547631579</TD><TD>Alper</TD><TD>11.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-2,108947368</TD><TD>Alper</TD><TD>21.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>21</TD><TD>0</TD><TD>Alper</TD><TD>05.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0</TD><TD>Alper</TD><TD>06.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>5,486842105</TD><TD>Alper</TD><TD>16.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-5,486842105</TD><TD>Alper</TD><TD>23.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>22</TD><TD>5,344342105</TD><TD>Alper</TD><TD>05.01.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-5,344342105</TD><TD>Alper</TD><TD>09.01.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>20</TD><TD>0</TD><TD>Alper</TD><TD>07.02.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>0</TD><TD>Alper</TD><TD>08.02.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>12</TD><TD>0</TD><TD>Alper</TD><TD>01.03.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0</TD><TD>Alper</TD><TD>14.03.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>22</TD><TD>0,004736842</TD><TD>Alper</TD><TD>05.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>10,47671053</TD><TD>Alper</TD><TD>07.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,197368421</TD><TD>Alper</TD><TD>11.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>28.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>14</TD><TD>-128,5439474</TD><TD>Alper</TD><TD>02.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,968947368</TD><TD>Alper</TD><TD>10.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>151,3157895</TD><TD>Alper</TD><TD>30.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>-145,7215789</TD><TD>Alper</TD><TD>01.06.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,526315789</TD><TD>Alper</TD><TD>07.06.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>13</TD><TD>0,857105263</TD><TD>Alper</TD><TD>03.07.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>13</TD><TD>0,857105263</TD><TD>Alper</TD><TD>01.08.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>-11,66289474</TD><TD>Alper</TD><TD>15.08.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-7,469342105</TD><TD>Alper</TD><TD>01.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>19</TD><TD>0</TD><TD>Alper</TD><TD>04.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>8,162368421</TD><TD>Alper</TD><TD>05.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-8,162368421</TD><TD>Alper</TD><TD>02.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>15</TD><TD>0</TD><TD>Alper</TD><TD>04.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>0</TD><TD>Alper</TD><TD>05.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>06.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>09.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>49,84065789</TD><TD>Alper</TD><TD>10.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-3,697368421</TD><TD>Alper</TD><TD>19.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>8</TD><TD>-46,14328947</TD><TD>Alper</TD><TD>01.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0</TD><TD>Alper</TD><TD>06.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>8</TD><TD>14,08381579</TD><TD>Alper</TD><TD>07.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>78,94736842</TD><TD>Alper</TD><TD>30.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-93,03118421</TD><TD>Alper</TD><TD>01.12.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>17</TD><TD>24,08513158</TD><TD>Alper</TD><TD>05.12.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>-24,08513158</TD><TD>Alper</TD><TD>02.01.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>12</TD><TD>0,697105263</TD><TD>Alper</TD><TD>08.01.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,697105263</TD><TD>Alper</TD><TD>01.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>11</TD><TD>0</TD><TD>Alper</TD><TD>05.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0,004210526</TD><TD>Alper</TD><TD>08.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>05.03.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,004210526</TD><TD>Alper</TD><TD>04.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>05.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0,656052632</TD><TD>Alper</TD><TD>06.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,101842105</TD><TD>Alper</TD><TD>02.05.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,757894737</TD><TD>Alper</TD><TD>01.06.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>0,859736842</TD><TD>Alper</TD><TD>04.06.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-0,859736842</TD><TD>Alper</TD><TD>02.07.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,948026316</TD><TD>Alper</TD><TD>03.07.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,948026316</TD><TD>Alper</TD><TD>01.08.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>1,426710526</TD><TD>Alper</TD><TD>06.08.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,1025</TD><TD>Alper</TD><TD>03.09.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>1,045789474</TD><TD>Alper</TD><TD>01.10.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>15,78947368</TD><TD>Alper</TD><TD>30.10.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-16,05947368</TD><TD>Alper</TD><TD>01.11.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-2,305</TD><TD>Alper</TD><TD>21.06.2024 00:00</TD></TR></TBODY></TABLE> Tue, 29 Oct 2024 07:32:05 GMT alperkeskin90 2024-10-29T07:32:05Z Daily Amount https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261157#M168882 <P>Hi,</P><P>&nbsp;</P><P>&nbsp;I have account number, account suffix, amount, name and trandate. I try to make a calculation. customer made his first transaction at 30/09/2015 which positive number and this means it is a investing money. There is also negative numbers which has - before it means taking money.&nbsp; I try to calculate customer's daily amount. In this example customer invest money at 30/09/2015. after this draw money. after that again draw money. I want to calculate end of day balance. Additionally, as you see the customer did not make any transaction at 03/10/2015. In this case last balance amount must be written to 03/10/2015 day balance. To sum up, I want to calculate daily balance whether the customers make transactions or not on calendar date. The date can be start beginning of the 2015 and can end on end of the 2025. If the calendar day before customer's first transaction day it can be null. I can not find any solution for this.<BR /><BR />PS: The data has 5 million rows so i can face with memory problems.<BR /><BR /></P><P><img /></P><P>&nbsp;</P> Mon, 28 Oct 2024 21:52:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261157#M168882 alperkeskin90 2024-10-28T21:52:11Z Re: Daily Amount https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261232#M168886 <P>Can you provide this data in text format ?</P> Mon, 28 Oct 2024 23:47:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261232#M168886 SachinNandanwar 2024-10-28T23:47:52Z Re: Daily Amount https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261749#M168908 <P>please find it below. Thank you</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>AccountNumber</TD><TD>Sum of AccountSuffix</TD><TD>Sum of Amount</TD><TD>CustomerName</TD><TD>TranDate</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>118,4210526</TD><TD>Alper</TD><TD>30.09.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-112,5921053</TD><TD>Alper</TD><TD>01.10.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-5,828947368</TD><TD>Alper</TD><TD>02.11.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>6,389473684</TD><TD>Alper</TD><TD>04.11.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-6,389473684</TD><TD>Alper</TD><TD>01.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>12,17039474</TD><TD>Alper</TD><TD>03.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-6,557894737</TD><TD>Alper</TD><TD>30.12.2015 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>65,78947368</TD><TD>Alper</TD><TD>05.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>06.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-193,1638158</TD><TD>Alper</TD><TD>12.01.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>-9,210526316</TD><TD>Alper</TD><TD>17.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,341315789</TD><TD>Alper</TD><TD>23.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>2,894736842</TD><TD>Alper</TD><TD>25.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-2,647368421</TD><TD>Alper</TD><TD>26.02.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>0,657894737</TD><TD>Alper</TD><TD>03.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-1,170526316</TD><TD>Alper</TD><TD>17.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>22.03.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>11.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>14.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>19.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>20.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,972894737</TD><TD>Alper</TD><TD>21.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>7,894736842</TD><TD>Alper</TD><TD>27.04.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-5,778684211</TD><TD>Alper</TD><TD>02.05.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-3,088947368</TD><TD>Alper</TD><TD>01.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0</TD><TD>Alper</TD><TD>06.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>07.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>2,718421053</TD><TD>Alper</TD><TD>13.06.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-2,718421053</TD><TD>Alper</TD><TD>01.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>171,0526316</TD><TD>Alper</TD><TD>07.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>08.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>-301,2509211</TD><TD>Alper</TD><TD>12.07.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-1,380657895</TD><TD>Alper</TD><TD>01.08.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0,727894737</TD><TD>Alper</TD><TD>03.08.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,727894737</TD><TD>Alper</TD><TD>01.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>06.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>07.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>11</TD><TD>1,051052632</TD><TD>Alper</TD><TD>08.09.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-1,051052632</TD><TD>Alper</TD><TD>04.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0,923289474</TD><TD>Alper</TD><TD>07.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-0,923289474</TD><TD>Alper</TD><TD>26.10.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>07.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>2,877105263</TD><TD>Alper</TD><TD>08.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-1,315789474</TD><TD>Alper</TD><TD>10.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>0,547631579</TD><TD>Alper</TD><TD>11.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-2,108947368</TD><TD>Alper</TD><TD>21.11.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>21</TD><TD>0</TD><TD>Alper</TD><TD>05.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0</TD><TD>Alper</TD><TD>06.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>5,486842105</TD><TD>Alper</TD><TD>16.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-5,486842105</TD><TD>Alper</TD><TD>23.12.2016 00:00</TD></TR><TR><TD>abc1245</TD><TD>22</TD><TD>5,344342105</TD><TD>Alper</TD><TD>05.01.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>-5,344342105</TD><TD>Alper</TD><TD>09.01.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>20</TD><TD>0</TD><TD>Alper</TD><TD>07.02.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>0</TD><TD>Alper</TD><TD>08.02.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>12</TD><TD>0</TD><TD>Alper</TD><TD>01.03.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0</TD><TD>Alper</TD><TD>14.03.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>22</TD><TD>0,004736842</TD><TD>Alper</TD><TD>05.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>10,47671053</TD><TD>Alper</TD><TD>07.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,197368421</TD><TD>Alper</TD><TD>11.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>131,5789474</TD><TD>Alper</TD><TD>28.04.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>14</TD><TD>-128,5439474</TD><TD>Alper</TD><TD>02.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,968947368</TD><TD>Alper</TD><TD>10.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>151,3157895</TD><TD>Alper</TD><TD>30.05.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>-145,7215789</TD><TD>Alper</TD><TD>01.06.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,526315789</TD><TD>Alper</TD><TD>07.06.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>13</TD><TD>0,857105263</TD><TD>Alper</TD><TD>03.07.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>13</TD><TD>0,857105263</TD><TD>Alper</TD><TD>01.08.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>-11,66289474</TD><TD>Alper</TD><TD>15.08.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-7,469342105</TD><TD>Alper</TD><TD>01.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>19</TD><TD>0</TD><TD>Alper</TD><TD>04.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>8,162368421</TD><TD>Alper</TD><TD>05.09.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-8,162368421</TD><TD>Alper</TD><TD>02.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>15</TD><TD>0</TD><TD>Alper</TD><TD>04.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>10</TD><TD>0</TD><TD>Alper</TD><TD>05.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>0</TD><TD>Alper</TD><TD>06.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0</TD><TD>Alper</TD><TD>09.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>49,84065789</TD><TD>Alper</TD><TD>10.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-3,697368421</TD><TD>Alper</TD><TD>19.10.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>8</TD><TD>-46,14328947</TD><TD>Alper</TD><TD>01.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>9</TD><TD>0</TD><TD>Alper</TD><TD>06.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>8</TD><TD>14,08381579</TD><TD>Alper</TD><TD>07.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>78,94736842</TD><TD>Alper</TD><TD>30.11.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-93,03118421</TD><TD>Alper</TD><TD>01.12.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>17</TD><TD>24,08513158</TD><TD>Alper</TD><TD>05.12.2017 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>-24,08513158</TD><TD>Alper</TD><TD>02.01.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>12</TD><TD>0,697105263</TD><TD>Alper</TD><TD>08.01.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,697105263</TD><TD>Alper</TD><TD>01.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>11</TD><TD>0</TD><TD>Alper</TD><TD>05.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>2</TD><TD>0,004210526</TD><TD>Alper</TD><TD>08.02.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>05.03.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>-0,004210526</TD><TD>Alper</TD><TD>04.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0</TD><TD>Alper</TD><TD>05.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>0,656052632</TD><TD>Alper</TD><TD>06.04.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,101842105</TD><TD>Alper</TD><TD>02.05.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,757894737</TD><TD>Alper</TD><TD>01.06.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>0,859736842</TD><TD>Alper</TD><TD>04.06.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>4</TD><TD>-0,859736842</TD><TD>Alper</TD><TD>02.07.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,948026316</TD><TD>Alper</TD><TD>03.07.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-0,948026316</TD><TD>Alper</TD><TD>01.08.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>7</TD><TD>1,426710526</TD><TD>Alper</TD><TD>06.08.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>5</TD><TD>0,1025</TD><TD>Alper</TD><TD>03.09.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>3</TD><TD>1,045789474</TD><TD>Alper</TD><TD>01.10.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>15,78947368</TD><TD>Alper</TD><TD>30.10.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-16,05947368</TD><TD>Alper</TD><TD>01.11.2018 00:00</TD></TR><TR><TD>abc1245</TD><TD>1</TD><TD>-2,305</TD><TD>Alper</TD><TD>21.06.2024 00:00</TD></TR></TBODY></TABLE> Tue, 29 Oct 2024 07:32:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4261749#M168908 alperkeskin90 2024-10-29T07:32:05Z Re: Daily Amount https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4263721#M168993 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="832129" data-lia-user-login="alperkeskin90" class="lia-mention lia-mention-user">alperkeskin90</a>&nbsp;<BR />Here Is your Solution.</P><P><img /><img /><img /></P><P>Steps to do:</P><P>1. Forst of all your "TranDate " is not in date format. So I did an extra step to create a calculated date column in the dataset.</P><P><img /></P><P>The formula Is as below:</P><DIV><DIV><SPAN>New Tran date =</SPAN></DIV><BR /><DIV><SPAN>var</SPAN> <SPAN>A</SPAN><SPAN> = </SPAN><SPAN>find</SPAN><SPAN>(</SPAN><SPAN>"."</SPAN><SPAN>,</SPAN><SPAN>'Table'</SPAN><SPAN>[TranDate]</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>var</SPAN> <SPAN>_day</SPAN><SPAN> = </SPAN><SPAN>left</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[TranDate]</SPAN><SPAN>,</SPAN><SPAN>A</SPAN><SPAN>-</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>B</SPAN><SPAN> = </SPAN><SPAN>FIND</SPAN><SPAN>(</SPAN><SPAN>"."</SPAN><SPAN>,</SPAN><SPAN>'Table'</SPAN><SPAN>[TranDate]</SPAN><SPAN>,</SPAN><SPAN>A</SPAN><SPAN>+</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>_month</SPAN><SPAN> = </SPAN><SPAN>mid</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[TranDate]</SPAN><SPAN>,</SPAN><SPAN>A</SPAN><SPAN>+</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>B</SPAN><SPAN>-</SPAN><SPAN>A</SPAN><SPAN>-</SPAN><SPAN>1</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>Var</SPAN> <SPAN>_year</SPAN><SPAN> = </SPAN><SPAN>mid</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[TranDate]</SPAN><SPAN>,</SPAN><SPAN>B</SPAN><SPAN>+</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>4</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN>return</SPAN></DIV><DIV><SPAN>date</SPAN><SPAN>(</SPAN><SPAN>_year</SPAN><SPAN>,</SPAN><SPAN>_month</SPAN><SPAN>,</SPAN><SPAN>_day</SPAN><SPAN>)</SPAN></DIV><DIV><SPAN><SPAN>2. Create a date table from 2015 to 2025<BR /></SPAN></SPAN><DIV><DIV><SPAN>Date =</SPAN> <SPAN>CALENDAR</SPAN><SPAN>(</SPAN><SPAN>date</SPAN><SPAN>(</SPAN><SPAN>2015</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>,</SPAN><SPAN>1</SPAN><SPAN>),</SPAN><SPAN>date</SPAN><SPAN>(</SPAN><SPAN>2025</SPAN><SPAN>,</SPAN><SPAN>12</SPAN><SPAN>,</SPAN><SPAN>31</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>3. Now Create a Measure to get cumulative sum of the amount for each customer. (Hope you have other customers as well.)<BR /></SPAN></SPAN><DIV><DIV><SPAN>Closing balance =</SPAN> <SPAN>calculate</SPAN><SPAN>(</SPAN><SPAN>sum</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>[Sum of Amount]</SPAN><SPAN>),</SPAN><SPAN>ALLEXCEPT</SPAN><SPAN>(</SPAN><SPAN>'Table'</SPAN><SPAN>,</SPAN><SPAN>'Table'</SPAN><SPAN>[CustomerName]</SPAN><SPAN>),</SPAN><SPAN>'Table'</SPAN><SPAN>[New Tran date]</SPAN><SPAN>&lt;=</SPAN><SPAN>max</SPAN><SPAN>(</SPAN><SPAN>'Date'</SPAN><SPAN>[Date]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>4. Now plot it in a Matrix using date from the date table in the row and the measure as value. Thats IT.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>hop this will work. If not, let me know.</SPAN></DIV></DIV></DIV></DIV></DIV></DIV> Wed, 30 Oct 2024 10:36:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Daily-Amount/m-p/4263721#M168993 Rupak_bi 2024-10-30T10:36:23Z