topic Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4256051#M168599 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378361" data-lia-user-login="Heena_9980400" class="lia-mention lia-mention-user">Heena_9980400</a>&nbsp;</P> <P>&nbsp;</P> <P>Thank you very much&nbsp;Rupak_bi&nbsp;and DanielW_&nbsp;for your prompt reply.</P> <P>&nbsp;</P> <P>Can you tell me if your problem is solved? If yes, please accept it as solution.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Nono Chen</P> <P>If this <STRONG><EM>post</EM></STRONG>&nbsp;helps, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Thu, 24 Oct 2024 09:07:03 GMT Anonymous 2024-10-24T09:07:03Z Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252007#M168383 <P>Hi Team,<BR /><BR />Hope you all are doing fine!</P><P>&nbsp;</P><P>Actually was trying to crreate 3 buttons like last 15 days,last 30 days and other than last 30 days.<BR />I tried achieving this by using below dax but for 30 days condition its giving only last 15 days data.</P><P>&nbsp;</P><DIV><DIV><SPAN>In the last= </SPAN></DIV><DIV><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN> ( tij2xgen5_formatted_pen_pedigree_dataset[penetestts], </SPAN><SPAN>TODAY</SPAN><SPAN>(), DAY ) &lt;= </SPAN><SPAN>15</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>"Last 15 days"</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>IF</SPAN><SPAN> (</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN> ( tij2xgen5_formatted_pen_pedigree_dataset[penetestts], </SPAN><SPAN>TODAY</SPAN><SPAN>(), DAY ) &gt; </SPAN><SPAN>15</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN> ( tij2xgen5_formatted_pen_pedigree_dataset[penetestts], </SPAN><SPAN>TODAY</SPAN><SPAN>(), DAY ) &lt;= </SPAN><SPAN>30</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Last 30 days"</SPAN><SPAN>, </SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Other than last 30 days"</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV><SPAN>)<BR /><BR />when i try without last 15 days conditions, it works fine but for above dax its not giving correct data.<BR /><BR />looking for your help.Thanks in advance.</SPAN></DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV>&nbsp;</DIV><DIV><SPAN>Regards,</SPAN></DIV><DIV><SPAN>Hk</SPAN></DIV></DIV> Tue, 22 Oct 2024 06:33:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252007#M168383 Heena_9980400 2024-10-22T06:33:23Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252039#M168384 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378361" data-lia-user-login="Heena_9980400" class="lia-mention lia-mention-user">Heena_9980400</a>&nbsp;<BR />your Dax should work. Alternatively you may try below simplified virsion as well. if doesn't works, check the date formats , else share sample data</P><DIV><SPAN>In the last=</SPAN></DIV><DIV><SPAN>var date_diff =&nbsp;DATEDIFF&nbsp;( tij2xgen5_formatted_pen_pedigree_dataset[penetestts],&nbsp;TODAY(), DAY )</SPAN></DIV><DIV>&nbsp;</DIV><DIV>return<BR />switch(true(), date_diff&lt;=15,<SPAN>"Last 15 days",date_diff&lt;=30,"Last 30 days","Other than last 30 days")</SPAN></DIV> Tue, 22 Oct 2024 06:50:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252039#M168384 Rupak_bi 2024-10-22T06:50:38Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252159#M168392 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="583487" data-lia-user-login="Rupak_bi" class="lia-mention lia-mention-user">Rupak_bi</a>&nbsp;,<BR /><BR />Thnaks for the response.<BR /><BR />still its not giving the correct answer, i checked the date format evrything, its correct.<BR />if i remove "last 15 days ". the last 30 days will correct data.<BR /><BR /></P><DIV><SPAN>In the last=</SPAN></DIV><DIV><SPAN>var date_diff =&nbsp;DATEDIFF&nbsp;( tij2xgen5_formatted_pen_pedigree_dataset[penetestts],&nbsp;TODAY(), DAY )</SPAN></DIV><DIV>&nbsp;</DIV><DIV>return<BR />switch(true(), <SPAN>date_diff&lt;=30,"Last 30 days","Other than last 30 days").<BR /><BR />when i add last 15 days condition, its not wroking for ast 30 days.<BR /><BR /></SPAN></DIV> Tue, 22 Oct 2024 08:02:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252159#M168392 Heena_9980400 2024-10-22T08:02:57Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252215#M168399 <P>plz share sample data in plain text here after replacing sensetive data with dummy.&nbsp;</P><P>&nbsp;</P> Tue, 22 Oct 2024 08:20:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252215#M168399 Rupak_bi 2024-10-22T08:20:41Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252345#M168405 <TABLE><TBODY><TR><TD>Year</TD><TD>Month</TD><TD>Day</TD><TD>productfamily</TD><TD>Count</TD><TD>AQ</TD><TD>MQ</TD><TD>S1</TD><TD>S2</TD><TD>S3</TD><TD>&nbsp;Line</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>1</TD><TD>xxxxx</TD><TD>1453</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>1</TD><TD>yyyyy</TD><TD>35</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>1</TD><TD>yyyyy</TD><TD>206</TD><TD>100.00%</TD><TD>99.51%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>1</TD><TD>xxxxx</TD><TD>6838</TD><TD>100.00%</TD><TD>94.79%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>1</TD><TD>zzzzz</TD><TD>1705</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>2</TD><TD>ttttt</TD><TD>424</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>2</TD><TD>xxxxx</TD><TD>576</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>2</TD><TD>xxxxx</TD><TD>3292</TD><TD>100.00%</TD><TD>99.64%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>2</TD><TD>zzzzz</TD><TD>7758</TD><TD>99.94%</TD><TD>99.73%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>3</TD><TD>xxxxx</TD><TD>809</TD><TD>100.00%</TD><TD>84.67%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>3</TD><TD>xxxxx</TD><TD>13083</TD><TD>100.00%</TD><TD>86.07%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>3</TD><TD>zzzzz</TD><TD>20258</TD><TD>99.80%</TD><TD>99.80%</TD><TD>99.99%</TD><TD>99.92%</TD><TD>99.89%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>ttttt</TD><TD>2</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>yyyyy</TD><TD>3</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>gggg</TD><TD>6078</TD><TD>100.00%</TD><TD>89.72%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>gggg</TD><TD>89</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>zzzzz</TD><TD>3</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>4</TD><TD>zzzzz</TD><TD>14808</TD><TD>100.00%</TD><TD>99.97%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>5</TD><TD>hhhhhhhh</TD><TD>6713</TD><TD>100.00%</TD><TD>86.30%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>5</TD><TD>zzzzz</TD><TD>16509</TD><TD>99.98%</TD><TD>99.27%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>6</TD><TD>hhhhhhhh</TD><TD>13844</TD><TD>100.00%</TD><TD>85.96%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>hhhhhhhh</TD><TD>2073</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>hhhhhhhh</TD><TD>14165</TD><TD>100.00%</TD><TD>85.54%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>hhhhhhhh</TD><TD>1</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>gggg</TD><TD>102</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>gggg</TD><TD>574</TD><TD>96.86%</TD><TD>96.86%</TD><TD>96.86%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>7</TD><TD>zzzzz</TD><TD>13974</TD><TD>99.99%</TD><TD>99.98%</TD><TD>100.00%</TD><TD>99.99%</TD><TD>99.99%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>8</TD><TD>hhhhhhhh</TD><TD>2247</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>8</TD><TD>hhhhhhhh</TD><TD>16111</TD><TD>100.00%</TD><TD>85.92%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>8</TD><TD>gggg</TD><TD>96</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>8</TD><TD>gggg</TD><TD>83</TD><TD>69.88%</TD><TD>69.88%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>8</TD><TD>zzzzz</TD><TD>12652</TD><TD>99.95%</TD><TD>99.94%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>9</TD><TD>hhhhhhhh</TD><TD>10391</TD><TD>100.00%</TD><TD>85.80%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>9</TD><TD>zzzzz</TD><TD>12118</TD><TD>100.00%</TD><TD>99.98%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>10</TD><TD>hhhhhhhh</TD><TD>20410</TD><TD>100.00%</TD><TD>86.07%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>10</TD><TD>gggg</TD><TD>94</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>10</TD><TD>gggg</TD><TD>29</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>10</TD><TD>zzzzz</TD><TD>2176</TD><TD>99.95%</TD><TD>99.95%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>11</TD><TD>hhhhhhhh</TD><TD>14951</TD><TD>100.00%</TD><TD>86.01%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>11</TD><TD>gggg</TD><TD>80</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>11</TD><TD>gggg</TD><TD>658</TD><TD>96.35%</TD><TD>96.35%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>11</TD><TD>zzzzz</TD><TD>24607</TD><TD>100.00%</TD><TD>99.94%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>12</TD><TD>hhhhhhhh</TD><TD>16617</TD><TD>99.99%</TD><TD>86.01%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>12</TD><TD>zzzzz</TD><TD>16546</TD><TD>99.99%</TD><TD>99.94%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>13</TD><TD>hhhhhhhh</TD><TD>13860</TD><TD>99.99%</TD><TD>85.53%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>13</TD><TD>CHAMELEON LG</TD><TD>297</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>14</TD><TD>hhhhhhhh</TD><TD>19164</TD><TD>100.00%</TD><TD>91.85%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>14</TD><TD>CHAMELEON LG</TD><TD>11698</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>14</TD><TD>CURIE LG</TD><TD>48</TD><TD>97.92%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>15</TD><TD>hhhhhhhh</TD><TD>21866</TD><TD>100.00%</TD><TD>97.17%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>15</TD><TD>CHAMELEON LG</TD><TD>17645</TD><TD>100.00%</TD><TD>99.98%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>15</TD><TD>CURIE LG</TD><TD>758</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>16</TD><TD>hhhhhhhh</TD><TD>5410</TD><TD>100.00%</TD><TD>97.01%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>16</TD><TD>CASSINI LG</TD><TD>50</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>16</TD><TD>CHAMELEON LG</TD><TD>14525</TD><TD>100.00%</TD><TD>99.99%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>16</TD><TD>CURIE LG</TD><TD>1006</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>17</TD><TD>hhhhhhhh</TD><TD>16483</TD><TD>100.00%</TD><TD>87.74%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>17</TD><TD>CASSINI LG</TD><TD>390</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>17</TD><TD>CHAMELEON LG</TD><TD>8944</TD><TD>100.00%</TD><TD>99.99%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>18</TD><TD>hhhhhhhh</TD><TD>20817</TD><TD>100.00%</TD><TD>86.00%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>18</TD><TD>CHAMELEON LG</TD><TD>16221</TD><TD>100.00%</TD><TD>99.98%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>19</TD><TD>hhhhhhhh</TD><TD>11854</TD><TD>100.00%</TD><TD>85.56%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>19</TD><TD>CHAMELEON LG</TD><TD>15681</TD><TD>100.00%</TD><TD>99.97%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>20</TD><TD>hhhhhhhh</TD><TD>13865</TD><TD>100.00%</TD><TD>85.75%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>20</TD><TD>CHAMELEON LG</TD><TD>6881</TD><TD>100.00%</TD><TD>99.99%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>21</TD><TD>hhhhhhhh</TD><TD>13400</TD><TD>100.00%</TD><TD>85.44%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>21</TD><TD>CASSINI LG</TD><TD>985</TD><TD>100.00%</TD><TD>0.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>zzzzz</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>21</TD><TD>CHAMELEON LG</TD><TD>11429</TD><TD>100.00%</TD><TD>99.98%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>22</TD><TD>hhhhhhhh</TD><TD>1735</TD><TD>100.00%</TD><TD>99.42%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR><TR><TD>2024</TD><TD>October</TD><TD>22</TD><TD>CHAMELEON LG</TD><TD>124</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>100.00%</TD><TD>yyyyy</TD></TR><TR><TD>2024</TD><TD>September</TD><TD>1</TD><TD>hhhhhhhh</TD><TD>1568</TD><TD>99.11%</TD><TD>99.11%</TD><TD>100.00%</TD><TD>0.00%</TD><TD>0.00%</TD><TD>xxxxx</TD></TR></TBODY></TABLE> Tue, 22 Oct 2024 09:36:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252345#M168405 Heena_9980400 2024-10-22T09:36:30Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252347#M168406 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="583487" data-lia-user-login="Rupak_bi" class="lia-mention lia-mention-user">Rupak_bi</a>&nbsp;,</P><P>&nbsp;</P><P>Please find the sample data above.</P> Tue, 22 Oct 2024 09:30:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252347#M168406 Heena_9980400 2024-10-22T09:30:22Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252411#M168413 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378361" data-lia-user-login="Heena_9980400" class="lia-mention lia-mention-user">Heena_9980400</a>&nbsp;,<BR />assuming the column [<SPAN>penetestts] is the date combination of [Year], [Month], [Day] in your test data, I believe I was able to created the desired effect witht the folowing dax column:<BR /></SPAN></P><DIV><DIV><SPAN>In</SPAN><SPAN> the last =</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>_TestDate</SPAN><SPAN> = </SPAN><SPAN>tij2xgen5_formatted_pen_pedigree_dataset</SPAN><SPAN>[penetestts]</SPAN></DIV><DIV><SPAN>VAR</SPAN> <SPAN>_TodayDate</SPAN><SPAN> = </SPAN><SPAN>TODAY</SPAN><SPAN>()</SPAN></DIV><DIV><SPAN>RETURN</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; </SPAN><SPAN>SWITCH</SPAN><SPAN>(</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>TRUE</SPAN><SPAN>(),</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>_TestDate</SPAN><SPAN>, </SPAN><SPAN>_TodayDate</SPAN><SPAN>, </SPAN><SPAN>DAY</SPAN><SPAN>) &lt;= </SPAN><SPAN>15</SPAN><SPAN>, </SPAN><SPAN>"Last 15 days"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>DATEDIFF</SPAN><SPAN>(</SPAN><SPAN>_TestDate</SPAN><SPAN>, </SPAN><SPAN>_TodayDate</SPAN><SPAN>, </SPAN><SPAN>DAY</SPAN><SPAN>) &lt;= </SPAN><SPAN>30</SPAN><SPAN>, </SPAN><SPAN>"Last 30 days"</SPAN><SPAN>,</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; &nbsp; &nbsp; </SPAN><SPAN>"Other than last 30 days"</SPAN></DIV><DIV><SPAN>&nbsp; &nbsp; )</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN><SPAN>Here is an example, counting the rows per category:<BR /></SPAN></SPAN><img /><P><SPAN>The SWITCH function is more efficient and makes it easier to read, compared to multiple nested IF-statements.</SPAN></P></DIV></DIV> Tue, 22 Oct 2024 16:32:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252411#M168413 DanielW_ 2024-10-22T16:32:09Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252455#M168415 <P>its working</P><P><img /></P><P><img /></P><P>Make sure you are you are converting month name to month number befor using datediff.</P><P>&nbsp;</P><P>If this solves your topic, please accept as solution.</P> Tue, 22 Oct 2024 10:40:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252455#M168415 Rupak_bi 2024-10-22T10:40:02Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252538#M168419 <P>You mean , in the DAX i need to change month name to month number or in calculated column.<BR /><BR />I did not get it, Could you please help me with the understanding.&nbsp;</P> Tue, 22 Oct 2024 11:49:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252538#M168419 Heena_9980400 2024-10-22T11:49:30Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252661#M168427 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378361" data-lia-user-login="Heena_9980400" class="lia-mention lia-mention-user">Heena_9980400</a>&nbsp;</P><P>See, your month column is in text format and "datediff" will work on date format only. So you need to transform month name to&nbsp; month number. Please refer the first variable in my DAX where I have a switch function converting month name to month number. I did it only for two months September and October . this you need to edit for all the months. thats it. your problem will be solved.<BR />I have created a calculated column as a solution, you may use the same dax to create a measure if required.&nbsp;</P><P>thanks.</P><P>&nbsp;</P><P>If this solves your problem, please accept as solution.</P> Tue, 22 Oct 2024 13:34:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4252661#M168427 Rupak_bi 2024-10-22T13:34:34Z Re: Trying to get 3 conditions, last 15 days, last 30 days and other than last 30 days DAX https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4256051#M168599 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="378361" data-lia-user-login="Heena_9980400" class="lia-mention lia-mention-user">Heena_9980400</a>&nbsp;</P> <P>&nbsp;</P> <P>Thank you very much&nbsp;Rupak_bi&nbsp;and DanielW_&nbsp;for your prompt reply.</P> <P>&nbsp;</P> <P>Can you tell me if your problem is solved? If yes, please accept it as solution.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Nono Chen</P> <P>If this <STRONG><EM>post</EM></STRONG>&nbsp;helps, then please consider&nbsp;<STRONG><EM>Accept it as the solution</EM></STRONG>&nbsp;to help the other members find it more quickly.</P> Thu, 24 Oct 2024 09:07:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Trying-to-get-3-conditions-last-15-days-last-30-days-and-other/m-p/4256051#M168599 Anonymous 2024-10-24T09:07:03Z