https://community.fabric.microsoft.com/t5/Developer/Need-help-with-cumulative-total-of-each-row-and-add-1-if-value/m-p/198914#M6342 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/20269">@n2p2gupta</a> wrote:<BR /> <P>I am learning DAX and need help to create DAX formula to calculate "Column2" by looking at each row in "Column1". &nbsp;If value repeats in "Column1" I would like to add +1 to the existing value in "Column2". &nbsp;Thanks for your help in advance.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 164px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/46625i9E74520E5C8FE1C1/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/20269">@n2p2gupta</a></P> <P>See the solution I posted in <A href="https://community.powerbi.com/t5/Developer/Calculate-cumulative-count-by-looking-values-in-a-column/m-p/196949" target="_self">your another thread</A>.</P> Thu, 22 Jun 2017 01:53:39 GMT Eric_Zhang 2017-06-22T01:53:39Z https://community.fabric.microsoft.com/t5/Developer/Need-help-with-cumulative-total-of-each-row-and-add-1-if-value/m-p/197694#M6296 <P>I am learning DAX and need help to create DAX formula to calculate "Column2" by looking at each row in "Column1". &nbsp;If value repeats in "Column1" I would like to add +1 to the existing value in "Column2". &nbsp;Thanks for your help in advance.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 164px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/46625i9E74520E5C8FE1C1/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>&nbsp;</P> Tue, 20 Jun 2017 17:05:54 GMT https://community.fabric.microsoft.com/t5/Developer/Need-help-with-cumulative-total-of-each-row-and-add-1-if-value/m-p/197694#M6296 n2p2gupta 2017-06-20T17:05:54Z https://community.fabric.microsoft.com/t5/Developer/Need-help-with-cumulative-total-of-each-row-and-add-1-if-value/m-p/198914#M6342 <BLOCKQUOTE><HR /><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/20269">@n2p2gupta</a> wrote:<BR /> <P>I am learning DAX and need help to create DAX formula to calculate "Column2" by looking at each row in "Column1". &nbsp;If value repeats in "Column1" I would like to add +1 to the existing value in "Column2". &nbsp;Thanks for your help in advance.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 164px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/46625i9E74520E5C8FE1C1/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/20269">@n2p2gupta</a></P> <P>See the solution I posted in <A href="https://community.powerbi.com/t5/Developer/Calculate-cumulative-count-by-looking-values-in-a-column/m-p/196949" target="_self">your another thread</A>.</P> Thu, 22 Jun 2017 01:53:39 GMT https://community.fabric.microsoft.com/t5/Developer/Need-help-with-cumulative-total-of-each-row-and-add-1-if-value/m-p/198914#M6342 Eric_Zhang 2017-06-22T01:53:39Z