topic Re: To group a numeric column containing the difference between 2 dates into same_day, day+1, &gt;1 day in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114334#M110202 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="524899" data-lia-user-login="Bu__" class="lia-mention lia-mention-user">Bu__</a>&nbsp;</P><P>try like:</P><DIV>categories =</DIV><DIV>SWITCH(</DIV><DIV>&nbsp; &nbsp; TRUE(),</DIV><DIV>&nbsp; &nbsp; [<SPAN>days between</SPAN>]=0, "same_day",</DIV><DIV>&nbsp; &nbsp; [days between]=1, "d+1",&nbsp;</DIV><DIV><SPAN>&nbsp; &nbsp; "&gt;1 day"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Mon, 06 Mar 2023 15:33:35 GMT FreemanZ 2023-03-06T15:33:35Z To group a numeric column containing the difference between 2 dates into same_day, day+1, >1 day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114308#M110198 <P>i want to convert a numeric column containing difference between 2 dates like (0,1,2,3..... so on) into 3 groups --&gt; same_day, d+1 and &gt;1 day</P><P>How to convert the numeric column and categorize them into 3 groups?</P><P>&nbsp;</P><P>days between (difference b/w 2 dates)|&nbsp; ---&gt; | 3 categories</P><P>0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; same day</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D+1 day</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;1 day</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;1 day</P><P>....</P><P>6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;1 day</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 06 Mar 2023 15:24:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114308#M110198 Bu__ 2023-03-06T15:24:09Z Re: To group a numeric column containing the difference between 2 dates into same_day, day+1, >1 day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114327#M110201 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="524899" data-lia-user-login="Bu__" class="lia-mention lia-mention-user">Bu__</a>&nbsp;</P> <P>please try<BR />=<BR />SWITCH (</P> <P>[days between],<BR />0, "same day",</P> <P>1, "D + 1 day",</P> <P>"&gt; 1 day"</P> <P>)</P> Mon, 06 Mar 2023 15:31:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114327#M110201 tamerj1 2023-03-06T15:31:29Z Re: To group a numeric column containing the difference between 2 dates into same_day, day+1, >1 day https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114334#M110202 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="524899" data-lia-user-login="Bu__" class="lia-mention lia-mention-user">Bu__</a>&nbsp;</P><P>try like:</P><DIV>categories =</DIV><DIV>SWITCH(</DIV><DIV>&nbsp; &nbsp; TRUE(),</DIV><DIV>&nbsp; &nbsp; [<SPAN>days between</SPAN>]=0, "same_day",</DIV><DIV>&nbsp; &nbsp; [days between]=1, "d+1",&nbsp;</DIV><DIV><SPAN>&nbsp; &nbsp; "&gt;1 day"</SPAN></DIV><DIV><SPAN>)</SPAN></DIV> Mon, 06 Mar 2023 15:33:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-group-a-numeric-column-containing-the-difference-between-2/m-p/3114334#M110202 FreemanZ 2023-03-06T15:33:35Z