topic Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742657#M145964 <P>first i want to sort top 5 by focusing the abs value of january month, and second requirement will be that top 5 spgrs i want to dispaly for comparision perpose sep 2023 to jan 2024. like this by using matrix table&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 05 Mar 2024 10:23:37 GMT tkavitha911 2024-03-05T10:23:37Z How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3739708#M145809 <P>input data&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;Out put i want to display like this&nbsp;</P><P><img /></P><P>&nbsp;</P> Mon, 04 Mar 2024 10:28:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3739708#M145809 tkavitha911 2024-03-04T10:28:12Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741192#M145900 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Mon, 04 Mar 2024 23:46:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741192#M145900 lbendlin 2024-03-04T23:46:23Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741498#M145909 <TABLE border="1"><TBODY><TR><TD>CHANNEL</TD><TD>SPGR Realinged</TD><TD>Period</TD><TD>M-3 Accuracy(Nivea)</TD><TD>abs</TD></TR><TR><TD>GT</TD><TD>80101</TD><TD>01-11-2023</TD><TD>0.3302</TD><TD>420380</TD></TR><TR><TD>GT</TD><TD>89059</TD><TD>01-11-2023</TD><TD>0.782095</TD><TD>292452</TD></TR><TR><TD>MT</TD><TD>89054</TD><TD>01-11-2023</TD><TD>0.587362</TD><TD>275705</TD></TR><TR><TD>MT</TD><TD>80204</TD><TD>01-11-2023</TD><TD>0.591634</TD><TD>266189</TD></TR><TR><TD>MT</TD><TD>80102</TD><TD>01-11-2023</TD><TD>0.467382</TD><TD>251847</TD></TR><TR><TD>GT</TD><TD>85281</TD><TD>01-12-2023</TD><TD>0</TD><TD>189464</TD></TR><TR><TD>MT</TD><TD>80204</TD><TD>01-12-2023</TD><TD>0.482066</TD><TD>177962.7</TD></TR><TR><TD>GT</TD><TD>89053-11</TD><TD>01-11-2023</TD><TD>0</TD><TD>175798</TD></TR><TR><TD>GT</TD><TD>89059</TD><TD>01-12-2023</TD><TD>0.308602</TD><TD>163544</TD></TR><TR><TD>GT</TD><TD>85281</TD><TD>01-11-2023</TD><TD>0.468827</TD><TD>140501</TD></TR><TR><TD>GT</TD><TD>80205</TD><TD>01-12-2023</TD><TD>0.662918</TD><TD>137774</TD></TR><TR><TD>GT</TD><TD>88835</TD><TD>01-01-2024</TD><TD>0</TD><TD>137513.7</TD></TR><TR><TD>MT</TD><TD>80101</TD><TD>01-11-2023</TD><TD>0.435667</TD><TD>132573</TD></TR><TR><TD>MT</TD><TD>81600</TD><TD>01-12-2023</TD><TD>0.104</TD><TD>130830.3</TD></TR><TR><TD>GT</TD><TD>85282</TD><TD>01-12-2023</TD><TD>0</TD><TD>130336</TD></TR><TR><TD>GT</TD><TD>89054</TD><TD>01-01-2024</TD><TD>0.547036</TD><TD>126425.4</TD></TR><TR><TD>MT</TD><TD>80204</TD><TD>01-01-2024</TD><TD>0</TD><TD>123852</TD></TR><TR><TD>GT</TD><TD>80201</TD><TD>01-11-2023</TD><TD>0.80208</TD><TD>123661</TD></TR><TR><TD>GT</TD><TD>80205</TD><TD>01-01-2024</TD><TD>0.269625</TD><TD>119651.4</TD></TR><TR><TD>GT</TD><TD>80204</TD><TD>01-11-2023</TD><TD>0.517204</TD><TD>116502</TD></TR><TR><TD>GT</TD><TD>89053</TD><TD>01-11-2023</TD><TD>0.776534</TD><TD>115515</TD></TR><TR><TD>GT</TD><TD>83840</TD><TD>01-11-2023</TD><TD>0.63675</TD><TD>114645</TD></TR><TR><TD>MT</TD><TD>80102</TD><TD>01-12-2023</TD><TD>0.416209</TD><TD>97904.11</TD></TR><TR><TD>GT</TD><TD>89054</TD><TD>01-12-2023</TD><TD>0.853225</TD><TD>93179</TD></TR><TR><TD>MT</TD><TD>89050</TD><TD>01-11-2023</TD><TD>0.53458</TD><TD>87989</TD></TR><TR><TD>GT</TD><TD>88408</TD><TD>01-11-2023</TD><TD>0.611332</TD><TD>86263</TD></TR><TR><TD>GT</TD><TD>81600</TD><TD>01-01-2024</TD><TD>0.308632</TD><TD>84340</TD></TR><TR><TD>GT</TD><TD>80201</TD><TD>01-01-2024</TD><TD>0</TD><TD>84168.07</TD></TR><TR><TD>GT</TD><TD>82252</TD><TD>01-01-2024</TD><TD>0</TD><TD>83918.05</TD></TR><TR><TD>GT</TD><TD>89050</TD><TD>01-11-2023</TD><TD>0.686211</TD><TD>81200</TD></TR><TR><TD>GT</TD><TD>89053</TD><TD>01-12-2023</TD><TD>0.627215</TD><TD>80151</TD></TR><TR><TD>MT</TD><TD>85077</TD><TD>01-11-2023</TD><TD>0.301145</TD><TD>79984</TD></TR><TR><TD>GT</TD><TD>80204</TD><TD>01-01-2024</TD><TD>0</TD><TD>76600.52</TD></TR><TR><TD>MT</TD><TD>85781</TD><TD>01-12-2023</TD><TD>0.520189</TD><TD>72678.93</TD></TR><TR><TD>GT</TD><TD>83734</TD><TD>01-12-2023</TD><TD>0.424544</TD><TD>69743</TD></TR><TR><TD>MT</TD><TD>82808</TD><TD>01-01-2024</TD><TD>0</TD><TD>69461.55</TD></TR><TR><TD>GT</TD><TD>80205</TD><TD>01-11-2023</TD><TD>0.962314</TD><TD>68829</TD></TR><TR><TD>GT</TD><TD>80101</TD><TD>01-12-2023</TD><TD>0.724009</TD><TD>67971</TD></TR><TR><TD>GT</TD><TD>87414</TD><TD>01-11-2023</TD><TD>0.5814</TD><TD>65994</TD></TR><TR><TD>MT</TD><TD>88476</TD><TD>01-11-2023</TD><TD>0.78422</TD><TD>65920</TD></TR><TR><TD>MT</TD><TD>88409</TD><TD>01-11-2023</TD><TD>0.437607</TD><TD>65363</TD></TR><TR><TD>GT</TD><TD>89050</TD><TD>01-01-2024</TD><TD>0</TD><TD>63715.01</TD></TR><TR><TD>GT</TD><TD>83731</TD><TD>01-01-2024</TD><TD>0.391011</TD><TD>62983.44</TD></TR><TR><TD>GT</TD><TD>82808</TD><TD>01-01-2024</TD><TD>0</TD><TD>62538.59</TD></TR><TR><TD>GT</TD><TD>80140</TD><TD>01-11-2023</TD><TD>0.284502</TD><TD>59767</TD></TR><TR><TD>GT</TD><TD>89053-11</TD><TD>01-12-2023</TD><TD>0</TD><TD>59538</TD></TR><TR><TD>GT</TD><TD>87400</TD><TD>01-01-2024</TD><TD>0</TD><TD>57841</TD></TR><TR><TD>GT</TD><TD>80305</TD><TD>01-11-2023</TD><TD>0.64954</TD><TD>57813</TD></TR><TR><TD>GT</TD><TD>81601</TD><TD>01-01-2024</TD><TD>0.339555</TD><TD>57573</TD></TR><TR><TD>GT</TD><TD>88868</TD><TD>01-01-2024</TD><TD>0</TD><TD>56768.93</TD></TR></TBODY></TABLE> Tue, 05 Mar 2024 02:57:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741498#M145909 tkavitha911 2024-03-05T02:57:47Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741514#M145911 <P>this is my sample data i want to write a dax for table creating for each channel top 5 SPGR's based on <STRONG>abs</STRONG> value then i want to display for each spgr accuracy percentage pls help me guys&nbsp;</P><P>&nbsp;</P> Tue, 05 Mar 2024 03:00:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741514#M145911 tkavitha911 2024-03-05T03:00:58Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741889#M145928 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="672212" data-lia-user-login="tkavitha911" class="lia-mention lia-mention-user">tkavitha911</a>&nbsp;,</P> <P>You can create a computing table to get the top five ABS among each CHANNEL.</P> <LI-CODE lang="markup">Top5spgr = Var RANKEDSPGR = Addcolumns ( 'Table', "RANK", RANKX (Filter (all ('table'), 'table' [channel] = Earlier ('table' [chaannel])), [abs], desc, dense) Cure Return SelectColumns ( Filter ( RANKEDSPGR, [Rank] &lt;= 5 ),, "Channel", [Channel], "Spgr", [spgr realinged], "Period", [Period], "Accuracy", [M-3 account (nivea)],], "ABS", [ABS] )</LI-CODE> <P>&nbsp;</P> <P>But I don't quite understand the percentage of the SPGR you said. It refers to who compares and who, which helps me better help you solve the problem.</P> <P>&nbsp;</P> <P>If your Current Period does not refer to this, please clarify in a follow-up reply.</P> <P>&nbsp;</P> <P>Best Regards,</P> <P>Clara Gong</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Tue, 05 Mar 2024 06:17:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741889#M145928 Anonymous 2024-03-05T06:17:24Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741953#M145932 <P>Heare i want to show top 5 for jamuary month&nbsp;</P><P>&nbsp;</P> Tue, 05 Mar 2024 06:49:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3741953#M145932 tkavitha911 2024-03-05T06:49:26Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742016#M145934 <P>heare i want to display january 2024 month for each channel top 5 spgr's by using the abs value heare no need to display accuracy nivea. (that is just for adding the values for different months in a visual)&nbsp;&nbsp;</P> Tue, 05 Mar 2024 07:17:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742016#M145934 tkavitha911 2024-03-05T07:17:03Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742111#M145940 <P>hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="672212" data-lia-user-login="tkavitha911" class="lia-mention lia-mention-user">tkavitha911</a>&nbsp;</P><P>&nbsp;</P><P>You can use a measure to RANK and filter data from Filter pane, but there must be some logic to make it dynamic(which month data you want to see?)</P><DIV><DIV><SPAN>Rank =</SPAN></DIV><DIV><SPAN>&nbsp;</SPAN><SPAN>RANK</SPAN><SPAN>(</SPAN><SPAN>DENSE</SPAN><SPAN>, </SPAN><SPAN>ALLSELECTED</SPAN><SPAN>(</SPAN><SPAN>'Rank'</SPAN><SPAN>), </SPAN><SPAN>ORDERBY</SPAN><SPAN>(</SPAN><SPAN>'Rank'</SPAN><SPAN>[abs]</SPAN><SPAN>, </SPAN><SPAN>DESC</SPAN><SPAN>), </SPAN><SPAN>PARTITIONBY</SPAN><SPAN>(</SPAN><SPAN>'Rank'</SPAN><SPAN>[CHANNEL]</SPAN><SPAN>))</SPAN></DIV><DIV>&nbsp;</DIV><DIV><img /><P>&nbsp;</P></DIV></DIV> Tue, 05 Mar 2024 07:44:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742111#M145940 talespin 2024-03-05T07:44:58Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742490#M145958 <P><SPAN>I want to display data for the month of January, focusing on absolute values, and the&nbsp;M-3 Accuracy(Nivea</SPAN></P><P><SPAN>percentage from September 2023 to January 2024. While I can currently display data for January alone, I specifically want to view only the absolute values for that month.&nbsp;</SPAN></P><P>&nbsp;</P> Tue, 05 Mar 2024 09:40:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742490#M145958 tkavitha911 2024-03-05T09:40:47Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742621#M145963 <P><SPAN>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="672212" data-lia-user-login="tkavitha911" class="lia-mention lia-mention-user">tkavitha911</a>&nbsp;</SPAN></P><P>&nbsp;</P><P><SPAN>I want to display data for the month of January - What is the logic, current month/previous month</SPAN></P><P><SPAN>which month?</SPAN></P> Tue, 05 Mar 2024 10:15:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742621#M145963 talespin 2024-03-05T10:15:57Z Re: How to create a table by using DAX for jan month top 5 each channel top 5 spgrs by taking abs value https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742657#M145964 <P>first i want to sort top 5 by focusing the abs value of january month, and second requirement will be that top 5 spgrs i want to dispaly for comparision perpose sep 2023 to jan 2024. like this by using matrix table&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 05 Mar 2024 10:23:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-create-a-table-by-using-DAX-for-jan-month-top-5-each/m-p/3742657#M145964 tkavitha911 2024-03-05T10:23:37Z