topic Re: Sort data over period and count - Multi Row Card in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817630#M149302 <P>Table Data_</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Date</TD><TD>IBN</TD><TD>Availability</TD></TR><TR><TD>5016</TD><TD>01-01-2023</TD><TD>01-02-2014</TD><TD>100%</TD></TR><TR><TD>5017</TD><TD>01-01-2023</TD><TD>01-04-2010</TD><TD>95%</TD></TR><TR><TD>5018</TD><TD>01-01-2023</TD><TD>01-09-2000</TD><TD>82%</TD></TR><TR><TD>5019</TD><TD>01-01-2023</TD><TD>01-07-1995</TD><TD>100%</TD></TR><TR><TD>5016</TD><TD>01-02-2023</TD><TD>01-02-2014</TD><TD>5%</TD></TR><TR><TD>5017</TD><TD>01-02-2023</TD><TD>01-04-2010</TD><TD>33%</TD></TR><TR><TD>5018</TD><TD>01-02-2023</TD><TD>01-09-2000</TD><TD>95%</TD></TR><TR><TD>5019</TD><TD>01-02-2023</TD><TD>01-07-1995</TD><TD>100%</TD></TR></TBODY></TABLE><P><BR />Dax Interval</P><TABLE border="1"><TBODY><TR><TD>Interval</TD><TD>Average<BR />Availability</TD></TR><TR><TD>95-100%</TD><TD>1</TD></TR><TR><TD>85-95%</TD><TD>1</TD></TR><TR><TD>65-85%</TD><TD>0</TD></TR><TR><TD>40-65%</TD><TD>2</TD></TR><TR><TD>20-40%</TD><TD>0</TD></TR><TR><TD>0-20%</TD><TD>0</TD></TR></TBODY></TABLE><P><BR />Dax age (Ex. 01/01-1985 - 31/12/1989)</P><TABLE border="1"><TBODY><TR><TD>Age</TD><TD>Average<BR />Availability</TD></TR><TR><TD>1985-1990</TD><TD>&nbsp;</TD></TR><TR><TD>1990-1995</TD><TD>&nbsp;</TD></TR><TR><TD>1995-2000</TD><TD>100%</TD></TR><TR><TD>2000-2005</TD><TD>89%</TD></TR><TR><TD>2005-2010</TD><TD>&nbsp;</TD></TR><TR><TD>2010-2015</TD><TD>58%</TD></TR><TR><TD>2015-2020</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 08 Apr 2024 05:28:00 GMT AndreasMEG 2024-04-08T05:28:00Z Sort data over period and count - Multi Row Card https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3813157#M149137 <P>I wish to sort and count the data as below.&nbsp;</P><P>I have Availability data from 01-01-2023 - 01-02-2024 and wish to know the average and sort it as shown in the left MultirowCard.</P><P>&nbsp;</P><P>I also wish to know the average Availability for the period sorted by age. (Right - MultirowCard)&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img />&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P> </P><P> </P><P>&nbsp;</P><P>&nbsp;</P> Fri, 05 Apr 2024 10:03:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3813157#M149137 AndreasMEG 2024-04-05T10:03:28Z Re: Sort data over period and count - Multi Row Card https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817135#M149285 <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> Sun, 07 Apr 2024 21:18:11 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817135#M149285 lbendlin 2024-04-07T21:18:11Z Re: Sort data over period and count - Multi Row Card https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817630#M149302 <P>Table Data_</P><TABLE border="1"><TBODY><TR><TD>ID</TD><TD>Date</TD><TD>IBN</TD><TD>Availability</TD></TR><TR><TD>5016</TD><TD>01-01-2023</TD><TD>01-02-2014</TD><TD>100%</TD></TR><TR><TD>5017</TD><TD>01-01-2023</TD><TD>01-04-2010</TD><TD>95%</TD></TR><TR><TD>5018</TD><TD>01-01-2023</TD><TD>01-09-2000</TD><TD>82%</TD></TR><TR><TD>5019</TD><TD>01-01-2023</TD><TD>01-07-1995</TD><TD>100%</TD></TR><TR><TD>5016</TD><TD>01-02-2023</TD><TD>01-02-2014</TD><TD>5%</TD></TR><TR><TD>5017</TD><TD>01-02-2023</TD><TD>01-04-2010</TD><TD>33%</TD></TR><TR><TD>5018</TD><TD>01-02-2023</TD><TD>01-09-2000</TD><TD>95%</TD></TR><TR><TD>5019</TD><TD>01-02-2023</TD><TD>01-07-1995</TD><TD>100%</TD></TR></TBODY></TABLE><P><BR />Dax Interval</P><TABLE border="1"><TBODY><TR><TD>Interval</TD><TD>Average<BR />Availability</TD></TR><TR><TD>95-100%</TD><TD>1</TD></TR><TR><TD>85-95%</TD><TD>1</TD></TR><TR><TD>65-85%</TD><TD>0</TD></TR><TR><TD>40-65%</TD><TD>2</TD></TR><TR><TD>20-40%</TD><TD>0</TD></TR><TR><TD>0-20%</TD><TD>0</TD></TR></TBODY></TABLE><P><BR />Dax age (Ex. 01/01-1985 - 31/12/1989)</P><TABLE border="1"><TBODY><TR><TD>Age</TD><TD>Average<BR />Availability</TD></TR><TR><TD>1985-1990</TD><TD>&nbsp;</TD></TR><TR><TD>1990-1995</TD><TD>&nbsp;</TD></TR><TR><TD>1995-2000</TD><TD>100%</TD></TR><TR><TD>2000-2005</TD><TD>89%</TD></TR><TR><TD>2005-2010</TD><TD>&nbsp;</TD></TR><TR><TD>2010-2015</TD><TD>58%</TD></TR><TR><TD>2015-2020</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 08 Apr 2024 05:28:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817630#M149302 AndreasMEG 2024-04-08T05:28:00Z Re: Sort data over period and count - Multi Row Card https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817632#M149303 <P><img /></P><P>&nbsp;</P> Mon, 08 Apr 2024 05:28:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3817632#M149303 AndreasMEG 2024-04-08T05:28:38Z Re: Sort data over period and count - Multi Row Card https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3821095#M149440 <P><img /><img /></P> <P>see attached.&nbsp; Please check the Power Query part - there is some data preparation required.</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 08 Apr 2024 22:42:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-data-over-period-and-count-Multi-Row-Card/m-p/3821095#M149440 lbendlin 2024-04-08T22:42:41Z