topic Re: Label month serially from selected periods in DAX in DAX Commands and Tips
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2513597#M69792
<P>I was actually on my way to solving the months labelling. This solves it perfectly.<BR /><BR />Thank you</P>Fri, 13 May 2022 13:26:06 GMTDataholic2022-05-13T13:26:06ZLabel month serially from selected periods in DAX
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2421365#M64161
<P>Hello all,</P><P><BR />I am working with a data set that contains the month in which the customers subscribed for services, and their monthly payment subsequently.<BR /><BR />The goal is to try and determine the number of customers that dropped off or who didn't make payments on a subsequent basis. I have been able to determine the count of customers on a monthly basis who dropped off.</P><P> </P><P>The data looks like this. I have put it in excel to simplify things </P><P> </P><TABLE><TBODY><TR><TD> </TD><TD> </TD><TD>Monthly Payments</TD></TR><TR><TD>Month subscribed</TD><TD> </TD><TD>Jan-21</TD><TD>Feb-21</TD><TD>Mar-21</TD><TD>Apr-21</TD><TD>May-21</TD><TD>Jun-21</TD><TD>Jul-21</TD><TD>Aug-21</TD><TD>Sep-21</TD><TD>Oct-21</TD><TD>Nov-21</TD><TD>Dec-21</TD><TD>Jan-22</TD><TD>Feb-22</TD><TD>Mar-22</TD><TD>Apr-22</TD></TR><TR><TD>Jan-21</TD><TD> </TD><TD>900</TD><TD>867</TD><TD>834</TD><TD>801</TD><TD>768</TD><TD>735</TD><TD>702</TD><TD>669</TD><TD>636</TD><TD>603</TD><TD>570</TD><TD>537</TD><TD>504</TD><TD>471</TD><TD>438</TD><TD> </TD></TR><TR><TD>Feb-21</TD><TD> </TD><TD> </TD><TD>800</TD><TD>767</TD><TD>734</TD><TD>701</TD><TD>668</TD><TD>635</TD><TD>602</TD><TD>569</TD><TD>536</TD><TD>503</TD><TD>470</TD><TD>437</TD><TD>404</TD><TD>371</TD><TD> </TD></TR><TR><TD>Mar-21</TD><TD> </TD><TD> </TD><TD> </TD><TD>940</TD><TD>907</TD><TD>874</TD><TD>841</TD><TD>808</TD><TD>775</TD><TD>742</TD><TD>709</TD><TD>676</TD><TD>643</TD><TD>610</TD><TD>577</TD><TD>544</TD><TD> </TD></TR><TR><TD>Apr-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>939</TD><TD>906</TD><TD>873</TD><TD>840</TD><TD>807</TD><TD>774</TD><TD>741</TD><TD>708</TD><TD>675</TD><TD>642</TD><TD>609</TD><TD>576</TD><TD> </TD></TR><TR><TD>May-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>310</TD><TD>277</TD><TD>244</TD><TD>211</TD><TD>178</TD><TD>145</TD><TD>112</TD><TD>79</TD><TD>46</TD><TD>13</TD><TD>0</TD><TD> </TD></TR><TR><TD>Jun-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>893</TD><TD>860</TD><TD>827</TD><TD>794</TD><TD>761</TD><TD>728</TD><TD>695</TD><TD>662</TD><TD>629</TD><TD>596</TD><TD> </TD></TR><TR><TD>Jul-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>493</TD><TD>460</TD><TD>427</TD><TD>394</TD><TD>361</TD><TD>328</TD><TD>295</TD><TD>262</TD><TD>229</TD><TD> </TD></TR><TR><TD>Aug-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>920</TD><TD>887</TD><TD>854</TD><TD>821</TD><TD>788</TD><TD>755</TD><TD>722</TD><TD>689</TD><TD> </TD></TR><TR><TD>Sep-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>120</TD><TD>87</TD><TD>54</TD><TD>21</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD> </TD></TR><TR><TD>Oct-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>222</TD><TD>189</TD><TD>156</TD><TD>123</TD><TD>90</TD><TD>57</TD><TD> </TD></TR><TR><TD>Nov-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>294</TD><TD>261</TD><TD>228</TD><TD>195</TD><TD>162</TD><TD> </TD></TR><TR><TD>Dec-21</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>748</TD><TD>715</TD><TD>682</TD><TD>649</TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>What I am trying to get at is to normalize the monthly progression of monthly payments relative to the subscription month to look like this;</P><P> </P><TABLE><TBODY><TR><TD> </TD><TD> </TD><TD>Monthly Payments</TD></TR><TR><TD>Month subscribed</TD><TD> </TD><TD>Month 1</TD><TD>Month 2</TD><TD>Month 3</TD><TD>Month 4</TD><TD>Month 5</TD><TD>Month 6</TD><TD>Month 7</TD><TD>Month 8</TD><TD>Month 9</TD><TD>Month 10</TD><TD>Month 11</TD><TD>Month 12</TD><TD>Month 13</TD><TD>Month 14</TD><TD>Month 15</TD><TD>Month 16</TD></TR><TR><TD>Jan-21</TD><TD> </TD><TD>900</TD><TD>867</TD><TD>834</TD><TD>801</TD><TD>768</TD><TD>735</TD><TD>702</TD><TD>669</TD><TD>636</TD><TD>603</TD><TD>570</TD><TD>537</TD><TD>504</TD><TD>471</TD><TD>438</TD><TD> </TD></TR><TR><TD>Feb-21</TD><TD> </TD><TD>800</TD><TD>767</TD><TD>734</TD><TD>701</TD><TD>668</TD><TD>635</TD><TD>602</TD><TD>569</TD><TD>536</TD><TD>503</TD><TD>470</TD><TD>437</TD><TD>404</TD><TD>371</TD><TD> </TD><TD> </TD></TR><TR><TD>Mar-21</TD><TD> </TD><TD>940</TD><TD>907</TD><TD>874</TD><TD>841</TD><TD>808</TD><TD>775</TD><TD>742</TD><TD>709</TD><TD>676</TD><TD>643</TD><TD>610</TD><TD>577</TD><TD>544</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Apr-21</TD><TD> </TD><TD>939</TD><TD>906</TD><TD>873</TD><TD>840</TD><TD>807</TD><TD>774</TD><TD>741</TD><TD>708</TD><TD>675</TD><TD>642</TD><TD>609</TD><TD>576</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>May-21</TD><TD> </TD><TD>310</TD><TD>277</TD><TD>244</TD><TD>211</TD><TD>178</TD><TD>145</TD><TD>112</TD><TD>79</TD><TD>46</TD><TD>13</TD><TD>0</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Jun-21</TD><TD> </TD><TD>893</TD><TD>860</TD><TD>827</TD><TD>794</TD><TD>761</TD><TD>728</TD><TD>695</TD><TD>662</TD><TD>629</TD><TD>596</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Jul-21</TD><TD> </TD><TD>493</TD><TD>460</TD><TD>427</TD><TD>394</TD><TD>361</TD><TD>328</TD><TD>295</TD><TD>262</TD><TD>229</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Aug-21</TD><TD> </TD><TD>920</TD><TD>887</TD><TD>854</TD><TD>821</TD><TD>788</TD><TD>755</TD><TD>722</TD><TD>689</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Sep-21</TD><TD> </TD><TD>120</TD><TD>87</TD><TD>54</TD><TD>21</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Oct-21</TD><TD> </TD><TD>222</TD><TD>189</TD><TD>156</TD><TD>123</TD><TD>90</TD><TD>57</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Nov-21</TD><TD> </TD><TD>294</TD><TD>261</TD><TD>228</TD><TD>195</TD><TD>162</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Dec-21</TD><TD> </TD><TD>748</TD><TD>715</TD><TD>682</TD><TD>649</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE><P> </P><P>Please bear in mind that to normalize this, I have to write a DAX to recognize the subscription month as "Month 1" and the subsequent months as "Month 2, Month 3, ..."<BR /><BR />Please help with this <LI-USER uid="148838"></LI-USER> <LI-USER uid="196136"></LI-USER> <LI-USER uid="317289"></LI-USER> </P>Mon, 28 Mar 2022 11:39:53 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2421365#M64161Dataholic2022-03-28T11:39:53ZRe: Label month serially from selected periods in DAX
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2421543#M64172
<P><LI-USER uid="372170"></LI-USER> , Seems like this one to me</P>
<P> </P>
<P>Customer Retention Part 3: Period Of Stay – Cohort Analysis: <A href="https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410" target="_blank">https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Analysis/ba-p/1393410</A></P>Mon, 28 Mar 2022 12:32:04 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2421543#M64172amitchandak2022-03-28T12:32:04ZRe: Label month serially from selected periods in DAX
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2513597#M69792
<P>I was actually on my way to solving the months labelling. This solves it perfectly.<BR /><BR />Thank you</P>Fri, 13 May 2022 13:26:06 GMThttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Label-month-serially-from-selected-periods-in-DAX/m-p/2513597#M69792Dataholic2022-05-13T13:26:06Z