https://community.fabric.microsoft.com/t5/Developer/Sorting-matrix-based-on-a-date-time-measure/m-p/1153153#M24117 <P>In my report I have a matrix:</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mn.PNG" style="width: 176px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/291547i21CCC1C78E67745A/image-size/large?v=v2&amp;px=999" role="button" title="mn.PNG" alt="mn.PNG" /></span></P><P>&nbsp;</P><P>and want to add measure2 to the Values and sort column1 in matrix based on measure2 so that it shows the latest date/time for column1:</P><P>&nbsp;</P><LI-CODE lang="markup">measure2:= MAX ('Salse'[Purchased time])</LI-CODE><P>&nbsp;</P><P>Here is a part of my report:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mn2.PNG" style="width: 564px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/291607i59C030764011F781/image-size/large?v=v2&amp;px=999" role="button" title="mn2.PNG" alt="mn2.PNG" /></span></P><P>I'm using tabular with fact and dimension tables.&nbsp;</P> Thu, 11 Jun 2020 14:32:23 GMT Anonymous 2020-06-11T14:32:23Z https://community.fabric.microsoft.com/t5/Developer/Sorting-matrix-based-on-a-date-time-measure/m-p/1153153#M24117 <P>In my report I have a matrix:</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mn.PNG" style="width: 176px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/291547i21CCC1C78E67745A/image-size/large?v=v2&amp;px=999" role="button" title="mn.PNG" alt="mn.PNG" /></span></P><P>&nbsp;</P><P>and want to add measure2 to the Values and sort column1 in matrix based on measure2 so that it shows the latest date/time for column1:</P><P>&nbsp;</P><LI-CODE lang="markup">measure2:= MAX ('Salse'[Purchased time])</LI-CODE><P>&nbsp;</P><P>Here is a part of my report:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mn2.PNG" style="width: 564px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/291607i59C030764011F781/image-size/large?v=v2&amp;px=999" role="button" title="mn2.PNG" alt="mn2.PNG" /></span></P><P>I'm using tabular with fact and dimension tables.&nbsp;</P> Thu, 11 Jun 2020 14:32:23 GMT https://community.fabric.microsoft.com/t5/Developer/Sorting-matrix-based-on-a-date-time-measure/m-p/1153153#M24117 Anonymous 2020-06-11T14:32:23Z