topic Re: Help please. in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3228009#M118294 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405743" data-lia-user-login="Puja" class="lia-mention lia-mention-user">Puja</a>&nbsp;</P><P>You have multiple lines show A23, rank2, previous year. Why line 5/28/2022 stand out?</P> Wed, 10 May 2023 02:11:13 GMT FreemanZ 2023-05-10T02:11:13Z Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227637#M118261 <P>I have a&nbsp; <STRONG>Date table</STRONG> with <STRONG>Date</STRONG>, <STRONG>Year</STRONG> and <STRONG>Rank&nbsp; </STRONG>and<STRONG> Catogery table </STRONG>with <STRONG>season_catogery </STRONG>and<STRONG> season _Year.</STRONG></P><P>My request is , when user select Season_Catogery <FONT color="#FF0000">A23</FONT>, then the result should show (Previos year) 5/28/2022 (Rank 2 )measure output.</P><P>EX: According to below test data I need to see&nbsp;<FONT color="#FF0000">29%</FONT>&nbsp; as a result.&nbsp;</P><TABLE><TBODY><TR><TD>5/28/2022</TD><TD>2022</TD><TD>2</TD><TD>A</TD><TD>2023</TD><TD><FONT color="#FF0000"><STRONG>29.00%</STRONG></FONT></TD></TR></TBODY></TABLE><P>Here is the test data.</P><TABLE><TBODY><TR><TD>Date</TD><TD>Year</TD><TD>Rank</TD><TD>Season_Category</TD><TD>Season_Year</TD><TD>MEASURE</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/3/2020</TD><TD>2020</TD><TD>1</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/17/2020</TD><TD>2020</TD><TD>2</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/31/2020</TD><TD>2020</TD><TD>3</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>11/3/2020</TD><TD>2020</TD><TD>1</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>11/14/2020</TD><TD>2020</TD><TD>2</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>12/5/2020</TD><TD>2020</TD><TD>1</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/2/2021</TD><TD>2021</TD><TD>1</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/16/2021</TD><TD>2021</TD><TD>2</TD><TD>B22</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/30/2021</TD><TD>2021</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>2/13/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>2/27/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>3/20/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>4/3/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>4/17/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>5/1/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>5/15/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>5/29/2021</TD><TD>2021</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>6/19/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>7/3/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>7/17/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>7/31/2021</TD><TD>2021</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>8/14/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>8/28/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>9/18/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/2/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/19/2021</TD><TD>2021</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>10/30/2021</TD><TD>2021</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>11/13/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>18.15%</TD></TR><TR><TD>12/4/2021</TD><TD>2021</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/1/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/15/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>0.00%</TD></TR><TR><TD>1/29/2022</TD><TD>2022</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>8.77%</TD></TR><TR><TD>2/12/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>22.15%</TD></TR><TR><TD>2/26/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>22.77%</TD></TR><TR><TD>3/19/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>26.54%</TD></TR><TR><TD>4/2/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>28.55%</TD></TR><TR><TD>4/16/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>41.78%</TD></TR><TR><TD>4/30/2022</TD><TD>2022</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>42.55%</TD></TR><TR><TD>5/14/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>53.70%</TD></TR><TR><TD>5/28/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>29.00%</TD></TR><TR><TD>6/18/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>72.79%</TD></TR><TR><TD>7/2/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>80.24%</TD></TR><TR><TD>7/16/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>86.35%</TD></TR><TR><TD>7/30/2022</TD><TD>2022</TD><TD>3</TD><TD>A23</TD><TD>2023</TD><TD>90.52%</TD></TR><TR><TD>8/20/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>92.19%</TD></TR><TR><TD>9/3/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>94.04%</TD></TR><TR><TD>9/17/2022</TD><TD>2022</TD><TD>2</TD><TD>A23</TD><TD>2023</TD><TD>94.35%</TD></TR><TR><TD>10/1/2022</TD><TD>2022</TD><TD>1</TD><TD>A23</TD><TD>2023</TD><TD>94.34%</TD></TR></TBODY></TABLE><P>Thanks a lot</P> Tue, 09 May 2023 17:45:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227637#M118261 Puja 2023-05-09T17:45:23Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227669#M118266 <P>Hello,</P><P>&nbsp;</P><P>Desired output not clear to me can you please elaborate some more to it.</P><P>&nbsp;</P><P>Thanks!</P><P>Ajendra Rawat</P> Tue, 09 May 2023 18:21:44 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227669#M118266 Ajendra 2023-05-09T18:21:44Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227679#M118268 <P>Hi ,</P><P>When user selects (in slicer)A23, the result should be&nbsp;<FONT color="#FF0000">29%</FONT><SPAN>&nbsp;.</SPAN></P><P><img /></P><P>&nbsp;</P><P><SPAN>Thank you&nbsp;</SPAN></P> Tue, 09 May 2023 18:51:33 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227679#M118268 Puja 2023-05-09T18:51:33Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227862#M118286 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405743" data-lia-user-login="Puja" class="lia-mention lia-mention-user">Puja</a>&nbsp;</P><P>why 29%, not the others?</P> Tue, 09 May 2023 22:40:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227862#M118286 FreemanZ 2023-05-09T22:40:46Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227884#M118288 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="460868" data-lia-user-login="FreemanZ" class="lia-mention lia-mention-user">FreemanZ</a>&nbsp;,</P><P>This is my request</P><P><SPAN>when user select Season_Catogery(in slicer) =&nbsp;</SPAN><FONT color="#FF0000">A23</FONT><SPAN>, then the result should show (Previos year) 5/28/2022 (Rank 2 )measure output.&nbsp;</SPAN></P><P><SPAN>Thank you</SPAN></P> Tue, 09 May 2023 23:15:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3227884#M118288 Puja 2023-05-09T23:15:43Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3228009#M118294 <P>Hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="405743" data-lia-user-login="Puja" class="lia-mention lia-mention-user">Puja</a>&nbsp;</P><P>You have multiple lines show A23, rank2, previous year. Why line 5/28/2022 stand out?</P> Wed, 10 May 2023 02:11:13 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3228009#M118294 FreemanZ 2023-05-10T02:11:13Z Re: Help please. https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3228643#M118378 <P>Thts what user want to see.&nbsp;</P><P>When the Catogery is selected , like A23, or B22 in slicer, it should pick Previous Year May Rank2 data only.</P><P>Anonymous</a>&nbsp;&nbsp;could you please help. I tried the whole day yesterday, couldnt get it correctly.</P><P>Thanks much.</P><P>&nbsp;</P><P>Thanks.</P> Wed, 10 May 2023 11:14:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-please/m-p/3228643#M118378 Puja 2023-05-10T11:14:59Z