topic Running total of period month in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-of-period-month/m-p/397089#M156510 <P>&nbsp;</P><P>Im new to Power BI ,Need some assistance is finding Running total/Accumilation in power BI</P><P>April = Open# (2)+Close#(3)/2 =3.5</P><P>May=&nbsp;<SPAN>Open# (2)+Close#(4)/2 =4</SPAN></P><P><SPAN>Marc=&nbsp;Open# (2)+Close#(19)/2 =11.5</SPAN></P><P><SPAN>etc...</SPAN></P><P>&nbsp;</P><P><SPAN>Open Count is fixed&nbsp; with April and Closed # varice by period&nbsp; month</SPAN></P><TABLE><TBODY><TR><TD>Period</TD><TD>Open #</TD><TD>Close #</TD><TD>&nbsp;</TD></TR><TR><TD>April</TD><TD>2</TD><TD>3</TD><TD>3.5</TD></TR><TR><TD>May</TD><TD>3</TD><TD>4</TD><TD>4</TD></TR><TR><TD>Jun</TD><TD>4</TD><TD>5</TD><TD>4.5</TD></TR><TR><TD>July</TD><TD>5</TD><TD>6</TD><TD>5</TD></TR><TR><TD>Aug</TD><TD>6</TD><TD>7</TD><TD>5.5</TD></TR><TR><TD>Sep</TD><TD>7</TD><TD>8</TD><TD>6</TD></TR><TR><TD>Oct</TD><TD>8</TD><TD>14</TD><TD>9</TD></TR><TR><TD>Nov</TD><TD>9</TD><TD>15</TD><TD>9.5</TD></TR><TR><TD>Dec</TD><TD>10</TD><TD>16</TD><TD>10</TD></TR><TR><TD>jan</TD><TD>11</TD><TD>17</TD><TD>10.5</TD></TR><TR><TD>Feb</TD><TD>12</TD><TD>18</TD><TD>11</TD></TR><TR><TD>Mar</TD><TD>13</TD><TD>19</TD><TD>11.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone help in methods in achiveing the out put</P> Mon, 16 Apr 2018 11:33:58 GMT Anonymous 2018-04-16T11:33:58Z Running total of period month https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-of-period-month/m-p/397089#M156510 <P>&nbsp;</P><P>Im new to Power BI ,Need some assistance is finding Running total/Accumilation in power BI</P><P>April = Open# (2)+Close#(3)/2 =3.5</P><P>May=&nbsp;<SPAN>Open# (2)+Close#(4)/2 =4</SPAN></P><P><SPAN>Marc=&nbsp;Open# (2)+Close#(19)/2 =11.5</SPAN></P><P><SPAN>etc...</SPAN></P><P>&nbsp;</P><P><SPAN>Open Count is fixed&nbsp; with April and Closed # varice by period&nbsp; month</SPAN></P><TABLE><TBODY><TR><TD>Period</TD><TD>Open #</TD><TD>Close #</TD><TD>&nbsp;</TD></TR><TR><TD>April</TD><TD>2</TD><TD>3</TD><TD>3.5</TD></TR><TR><TD>May</TD><TD>3</TD><TD>4</TD><TD>4</TD></TR><TR><TD>Jun</TD><TD>4</TD><TD>5</TD><TD>4.5</TD></TR><TR><TD>July</TD><TD>5</TD><TD>6</TD><TD>5</TD></TR><TR><TD>Aug</TD><TD>6</TD><TD>7</TD><TD>5.5</TD></TR><TR><TD>Sep</TD><TD>7</TD><TD>8</TD><TD>6</TD></TR><TR><TD>Oct</TD><TD>8</TD><TD>14</TD><TD>9</TD></TR><TR><TD>Nov</TD><TD>9</TD><TD>15</TD><TD>9.5</TD></TR><TR><TD>Dec</TD><TD>10</TD><TD>16</TD><TD>10</TD></TR><TR><TD>jan</TD><TD>11</TD><TD>17</TD><TD>10.5</TD></TR><TR><TD>Feb</TD><TD>12</TD><TD>18</TD><TD>11</TD></TR><TR><TD>Mar</TD><TD>13</TD><TD>19</TD><TD>11.5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Can someone help in methods in achiveing the out put</P> Mon, 16 Apr 2018 11:33:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Running-total-of-period-month/m-p/397089#M156510 Anonymous 2018-04-16T11:33:58Z