https://community.fabric.microsoft.com/t5/Developer/New-column-creation/m-p/912709#M22108 <P>Hello,</P><P>&nbsp;</P><P>I´m trying to create a new column (Flag) that show the values 0 or 1.</P><P>The value of this column should be 1 if there are one or more rows with Managed &gt; 0 for the same Country on the last 10 days.</P><P>&nbsp;</P><P>For example:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Managed.PNG" style="width: 323px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/229407iFD70F1A172340CD9/image-size/large?v=v2&amp;px=999" role="button" title="Managed.PNG" alt="Managed.PNG" /></span></P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Thanks for your help!</P> Wed, 29 Jan 2020 08:25:33 GMT Anonymous 2020-01-29T08:25:33Z https://community.fabric.microsoft.com/t5/Developer/New-column-creation/m-p/912709#M22108 <P>Hello,</P><P>&nbsp;</P><P>I´m trying to create a new column (Flag) that show the values 0 or 1.</P><P>The value of this column should be 1 if there are one or more rows with Managed &gt; 0 for the same Country on the last 10 days.</P><P>&nbsp;</P><P>For example:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Managed.PNG" style="width: 323px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/229407iFD70F1A172340CD9/image-size/large?v=v2&amp;px=999" role="button" title="Managed.PNG" alt="Managed.PNG" /></span></P><P>&nbsp;</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>Thanks for your help!</P> Wed, 29 Jan 2020 08:25:33 GMT https://community.fabric.microsoft.com/t5/Developer/New-column-creation/m-p/912709#M22108 Anonymous 2020-01-29T08:25:33Z https://community.fabric.microsoft.com/t5/Developer/New-column-creation/m-p/912736#M22109 <P>In sql a posible solution is the following pseudocode but I need to do it in DAX.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="Pseudocode.PNG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/229416i0364AEFC8699419C/image-size/large?v=v2&amp;px=999" role="button" title="Pseudocode.PNG" alt="Pseudocode.PNG" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 27 Jan 2020 17:49:24 GMT https://community.fabric.microsoft.com/t5/Developer/New-column-creation/m-p/912736#M22109 Anonymous 2020-01-27T17:49:24Z