topic Find a LAST ORDER DATE in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-a-LAST-ORDER-DATE/m-p/1347483#M24173 <P>Hi everyboy,</P><P>I have a problem. Now it is a big problem. I went through all threads about DAX &amp; PowerBI and I cannot find a correct solution.<BR />What is the point?</P><P>I have a dataset to analyze. It includes:<BR />- "Article" table where different articles (items) are stored<BR />- "Warehouse Documents" table where each order has its own counterpart; each order can have more than one article on it of course<BR />- "Position of Warehouse Documents" table that has connection to "Warehouse Documents" and "Article" so I can find for instance on which orders one single article has been sold and etc</P><P>So, I have already made a different measures, calculations and so on and it works quite fine.<BR />But, I am stucked with one info: I would like to add to my dashboard - the DATE of the LAST ORDER for ARTICLE</P><P>&nbsp;</P><P>Let's get the example:</P><P>"ARTICLE" table:</P><TABLE border="1"><TBODY><TR><TD>Product_Name</TD><TD>TradeIndex</TD><TD>UniquePrice</TD><TD>Category</TD><TD>ID_Article</TD></TR><TR><TD>Item_1</TD><TD>12345671</TD><TD>12,45€</TD><TD>A1</TD><TD>1</TD></TR><TR><TD>Item_2</TD><TD>12345672</TD><TD>23,56€</TD><TD>A2</TD><TD>2</TD></TR><TR><TD>Item_3</TD><TD>12345673</TD><TD>10,00€</TD><TD>B1</TD><TD>3</TD></TR><TR><TD>Item_4</TD><TD>12345674</TD><TD>21,50€</TD><TD>B1</TD><TD>4</TD></TR><TR><TD>Item_5</TD><TD>12345675</TD><TD>8,56€</TD><TD>B1</TD><TD>5</TD></TR><TR><TD>Item_6</TD><TD>12345676</TD><TD>100,00€</TD><TD>A2</TD><TD>6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>"WAREHOUSE DOCUMENTS" table:</P><TABLE border="1"><TBODY><TR><TD>&nbsp;</TD><TD>Date</TD><TD>ID_WAREHOUSE_DOCUMENTS</TD></TR><TR><TD>Order_1</TD><TD>&nbsp; &nbsp; 12.04.2010</TD><TD>&nbsp; &nbsp; &nbsp;1</TD></TR><TR><TD>Order_2</TD><TD>&nbsp; &nbsp; 18.07.2011</TD><TD>&nbsp; &nbsp; &nbsp;2</TD></TR><TR><TD>Order_3</TD><TD>&nbsp; &nbsp; 21.03.2015</TD><TD>&nbsp; &nbsp; &nbsp;3</TD></TR><TR><TD>Order_4</TD><TD>&nbsp; &nbsp; 22.05.2019</TD><TD>&nbsp; &nbsp; &nbsp;4</TD></TR><TR><TD>Order_5</TD><TD>&nbsp; &nbsp; 18.03.2020</TD><TD>&nbsp; &nbsp; &nbsp;5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>"Position Warehouse Documents" table:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>ID_Position_Warehouse_Documents</TD><TD>ID_Warehouse_Documents</TD><TD>Date</TD><TD>ID_Article</TD><TD>Quantity</TD><TD>Price</TD></TR><TR><TD>1</TD><TD>1</TD><TD>12.04.2010</TD><TD>2</TD><TD>10</TD><TD>100€</TD></TR><TR><TD>2</TD><TD>1</TD><TD>12.04.2010</TD><TD>1</TD><TD>20</TD><TD>199€</TD></TR><TR><TD>3</TD><TD>2</TD><TD>18.07.2011</TD><TD>2</TD><TD>14</TD><TD>140€</TD></TR><TR><TD>4</TD><TD>2</TD><TD>18.07.2011</TD><TD>3</TD><TD>10</TD><TD>150€</TD></TR><TR><TD>5</TD><TD>2</TD><TD>18.07.2011</TD><TD>1</TD><TD>1</TD><TD>200€</TD></TR><TR><TD>6</TD><TD>3</TD><TD>21.03.2015</TD><TD>2</TD><TD>2</TD><TD>50€</TD></TR><TR><TD>7</TD><TD>3</TD><TD>21.03.2015</TD><TD>4</TD><TD>10</TD><TD>20€</TD></TR><TR><TD>8</TD><TD>3</TD><TD>21.03.2015</TD><TD>3</TD><TD>5</TD><TD>10€</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>As you see ARTICLE "<FONT color="#FF0000"><STRONG>Item_2</STRONG></FONT>" has been sold <STRONG>three times</STRONG> and I would like to get the <STRONG>DATE</STRONG> of the <STRONG>LAST ORDER</STRONG> so in this case would be : <FONT color="#339966"><STRONG>21.03.2015</STRONG></FONT><BR />For <FONT color="#FF0000"><STRONG>Item_1</STRONG></FONT> it would be <FONT color="#339966"><STRONG>18.07.2011</STRONG> </FONT>and for <STRONG><FONT color="#FF0000">Item_3</FONT> = <FONT color="#339966">21.03.2015</FONT></STRONG></P><P>&nbsp;</P><P>Can you tell me how I can calculate it?</P><P>I have already tried different functions: CALCULATE, CALCULATETABLE, ADDCOLUMNS and many others but to be honest I don't know which one I should use.&nbsp;Honestly I am lost here ... I hope the example is clear.<BR />If not please let me know. Thanks in advance for any suggestions - it shoulnd't be so tricky <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P>BR,<BR />MrAnalytic</P> Fri, 04 Sep 2020 11:44:49 GMT MrAnalytic 2020-09-04T11:44:49Z Find a LAST ORDER DATE https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-a-LAST-ORDER-DATE/m-p/1347483#M24173 <P>Hi everyboy,</P><P>I have a problem. Now it is a big problem. I went through all threads about DAX &amp; PowerBI and I cannot find a correct solution.<BR />What is the point?</P><P>I have a dataset to analyze. It includes:<BR />- "Article" table where different articles (items) are stored<BR />- "Warehouse Documents" table where each order has its own counterpart; each order can have more than one article on it of course<BR />- "Position of Warehouse Documents" table that has connection to "Warehouse Documents" and "Article" so I can find for instance on which orders one single article has been sold and etc</P><P>So, I have already made a different measures, calculations and so on and it works quite fine.<BR />But, I am stucked with one info: I would like to add to my dashboard - the DATE of the LAST ORDER for ARTICLE</P><P>&nbsp;</P><P>Let's get the example:</P><P>"ARTICLE" table:</P><TABLE border="1"><TBODY><TR><TD>Product_Name</TD><TD>TradeIndex</TD><TD>UniquePrice</TD><TD>Category</TD><TD>ID_Article</TD></TR><TR><TD>Item_1</TD><TD>12345671</TD><TD>12,45€</TD><TD>A1</TD><TD>1</TD></TR><TR><TD>Item_2</TD><TD>12345672</TD><TD>23,56€</TD><TD>A2</TD><TD>2</TD></TR><TR><TD>Item_3</TD><TD>12345673</TD><TD>10,00€</TD><TD>B1</TD><TD>3</TD></TR><TR><TD>Item_4</TD><TD>12345674</TD><TD>21,50€</TD><TD>B1</TD><TD>4</TD></TR><TR><TD>Item_5</TD><TD>12345675</TD><TD>8,56€</TD><TD>B1</TD><TD>5</TD></TR><TR><TD>Item_6</TD><TD>12345676</TD><TD>100,00€</TD><TD>A2</TD><TD>6</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>"WAREHOUSE DOCUMENTS" table:</P><TABLE border="1"><TBODY><TR><TD>&nbsp;</TD><TD>Date</TD><TD>ID_WAREHOUSE_DOCUMENTS</TD></TR><TR><TD>Order_1</TD><TD>&nbsp; &nbsp; 12.04.2010</TD><TD>&nbsp; &nbsp; &nbsp;1</TD></TR><TR><TD>Order_2</TD><TD>&nbsp; &nbsp; 18.07.2011</TD><TD>&nbsp; &nbsp; &nbsp;2</TD></TR><TR><TD>Order_3</TD><TD>&nbsp; &nbsp; 21.03.2015</TD><TD>&nbsp; &nbsp; &nbsp;3</TD></TR><TR><TD>Order_4</TD><TD>&nbsp; &nbsp; 22.05.2019</TD><TD>&nbsp; &nbsp; &nbsp;4</TD></TR><TR><TD>Order_5</TD><TD>&nbsp; &nbsp; 18.03.2020</TD><TD>&nbsp; &nbsp; &nbsp;5</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>"Position Warehouse Documents" table:</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>ID_Position_Warehouse_Documents</TD><TD>ID_Warehouse_Documents</TD><TD>Date</TD><TD>ID_Article</TD><TD>Quantity</TD><TD>Price</TD></TR><TR><TD>1</TD><TD>1</TD><TD>12.04.2010</TD><TD>2</TD><TD>10</TD><TD>100€</TD></TR><TR><TD>2</TD><TD>1</TD><TD>12.04.2010</TD><TD>1</TD><TD>20</TD><TD>199€</TD></TR><TR><TD>3</TD><TD>2</TD><TD>18.07.2011</TD><TD>2</TD><TD>14</TD><TD>140€</TD></TR><TR><TD>4</TD><TD>2</TD><TD>18.07.2011</TD><TD>3</TD><TD>10</TD><TD>150€</TD></TR><TR><TD>5</TD><TD>2</TD><TD>18.07.2011</TD><TD>1</TD><TD>1</TD><TD>200€</TD></TR><TR><TD>6</TD><TD>3</TD><TD>21.03.2015</TD><TD>2</TD><TD>2</TD><TD>50€</TD></TR><TR><TD>7</TD><TD>3</TD><TD>21.03.2015</TD><TD>4</TD><TD>10</TD><TD>20€</TD></TR><TR><TD>8</TD><TD>3</TD><TD>21.03.2015</TD><TD>3</TD><TD>5</TD><TD>10€</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>As you see ARTICLE "<FONT color="#FF0000"><STRONG>Item_2</STRONG></FONT>" has been sold <STRONG>three times</STRONG> and I would like to get the <STRONG>DATE</STRONG> of the <STRONG>LAST ORDER</STRONG> so in this case would be : <FONT color="#339966"><STRONG>21.03.2015</STRONG></FONT><BR />For <FONT color="#FF0000"><STRONG>Item_1</STRONG></FONT> it would be <FONT color="#339966"><STRONG>18.07.2011</STRONG> </FONT>and for <STRONG><FONT color="#FF0000">Item_3</FONT> = <FONT color="#339966">21.03.2015</FONT></STRONG></P><P>&nbsp;</P><P>Can you tell me how I can calculate it?</P><P>I have already tried different functions: CALCULATE, CALCULATETABLE, ADDCOLUMNS and many others but to be honest I don't know which one I should use.&nbsp;Honestly I am lost here ... I hope the example is clear.<BR />If not please let me know. Thanks in advance for any suggestions - it shoulnd't be so tricky <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span></P><P>&nbsp;</P><P>BR,<BR />MrAnalytic</P> Fri, 04 Sep 2020 11:44:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-a-LAST-ORDER-DATE/m-p/1347483#M24173 MrAnalytic 2020-09-04T11:44:49Z Re: Find a LAST ORDER DATE https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-a-LAST-ORDER-DATE/m-p/1357358#M24546 <P>Hey,</P> <P>&nbsp;</P> <P>You can just use the measure</P> <LI-CODE lang="markup">Measure 3 = MAX('Position Warehouse Documents'[Date])</LI-CODE> <P>See screenshot:</P> <P>&nbsp;</P> <P><img /></P> <P>Eric.</P> Wed, 09 Sep 2020 07:56:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Find-a-LAST-ORDER-DATE/m-p/1357358#M24546 Anonymous 2020-09-09T07:56:34Z