topic Re: DAX finding dates in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3204253#M116643 <P>Hello, actually the data was wrong. I am pasting the corrected ones now.</P><P>In this list, the maximum date is 24/04/2023.<BR />However, I want to be able to calculate the next e.g.<BR />22/04/2023 (max-1) and another 17/04/2023 (max-2), i.e. subsequent dates in a decreasing sequence. The function must include a filter for a specific product id.</P><P>At the same time, the result of this function is supposed to be a filter to find other values ​​from a table row.<BR />e.g.<BR />date 22/04.2023 for product id 25, is to be a filter to the sales quantity for a given date and product id.</P><P>&nbsp;</P> Tue, 25 Apr 2023 05:37:51 GMT s_kula 2023-04-25T05:37:51Z DAX finding dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3193542#M115870 <P>Hello, I need to calculate 2 values ​​using DAX function.<BR />1. Calculate the penultimate date for product id<BR />2. Calculate the quantity for a given date and product id.</P><P>an example table with data is attached.</P><P>I will be grateful for your help.</P><P><BR />id prod&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;qty</P><TABLE><TBODY><TR><TD>82</TD><TD>17.04.2023</TD><TD>4</TD></TR><TR><TD>801</TD><TD>17.04.2023</TD><TD>5</TD></TR><TR><TD>632</TD><TD>17.04.2023</TD><TD>11</TD></TR><TR><TD>632</TD><TD>17.04.2023</TD><TD>11</TD></TR><TR><TD>5583-2</TD><TD>17.04.2023</TD><TD>3</TD></TR><TR><TD>5583-1</TD><TD>17.04.2023</TD><TD>3</TD></TR><TR><TD>5536</TD><TD>17.04.2023</TD><TD>30</TD></TR><TR><TD>5535</TD><TD>17.04.2023</TD><TD>9</TD></TR><TR><TD>5533</TD><TD>17.04.2023</TD><TD>9</TD></TR><TR><TD>5531</TD><TD>17.04.2023</TD><TD>9</TD></TR><TR><TD>5528-1</TD><TD>17.04.2023</TD><TD>20</TD></TR><TR><TD>5527-4</TD><TD>17.04.2023</TD><TD>1</TD></TR><TR><TD>5526-4</TD><TD>16.04.2023</TD><TD>6</TD></TR><TR><TD>5526-3</TD><TD>16.04.2023</TD><TD>6</TD></TR><TR><TD>5526-1</TD><TD>16.04.2023</TD><TD>6</TD></TR><TR><TD>5525-3</TD><TD>16.04.2023</TD><TD>20</TD></TR><TR><TD>5525-1</TD><TD>16.04.2023</TD><TD>20</TD></TR><TR><TD>5523-2</TD><TD>16.04.2023</TD><TD>26</TD></TR><TR><TD>5522</TD><TD>16.04.2023</TD><TD>4</TD></TR><TR><TD>5521</TD><TD>16.04.2023</TD><TD>4</TD></TR><TR><TD>5517</TD><TD>16.04.2023</TD><TD>4</TD></TR><TR><TD>5516</TD><TD>16.04.2023</TD><TD>8</TD></TR><TR><TD>5515</TD><TD>16.04.2023</TD><TD>5</TD></TR><TR><TD>5510-5</TD><TD>16.04.2023</TD><TD>4</TD></TR><TR><TD>5486</TD><TD>16.04.2023</TD><TD>12</TD></TR><TR><TD>5485</TD><TD>16.04.2023</TD><TD>12</TD></TR><TR><TD>5481</TD><TD>15.04.2023</TD><TD>12</TD></TR><TR><TD>5423</TD><TD>15.04.2023</TD><TD>2</TD></TR><TR><TD>5421</TD><TD>15.04.2023</TD><TD>1</TD></TR><TR><TD>5415</TD><TD>15.04.2023</TD><TD>10</TD></TR><TR><TD>5309-1</TD><TD>15.04.2023</TD><TD>1</TD></TR><TR><TD>5280</TD><TD>15.04.2023</TD><TD>10</TD></TR><TR><TD>5261</TD><TD>15.04.2023</TD><TD>2</TD></TR><TR><TD>525-2</TD><TD>15.04.2023</TD><TD>3</TD></TR><TR><TD>525-1</TD><TD>15.04.2023</TD><TD>5</TD></TR><TR><TD>524</TD><TD>15.04.2023</TD><TD>96</TD></TR><TR><TD>5226-1</TD><TD>15.04.2023</TD><TD>3</TD></TR><TR><TD>5220-2</TD><TD>15.04.2023</TD><TD>6</TD></TR><TR><TD>522</TD><TD>15.04.2023</TD><TD>96</TD></TR><TR><TD>5219-1</TD><TD>15.04.2023</TD><TD>10</TD></TR><TR><TD>5217-1</TD><TD>15.04.2023</TD><TD>5</TD></TR><TR><TD>5215-2</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>518-2</TD><TD>14.04.2023</TD><TD>30</TD></TR><TR><TD>518-1</TD><TD>14.04.2023</TD><TD>50</TD></TR><TR><TD>5043-5</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>5043-4</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>5043-3</TD><TD>14.04.2023</TD><TD>4</TD></TR><TR><TD>5043-1</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>5041-3</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>5041-1</TD><TD>14.04.2023</TD><TD>6</TD></TR><TR><TD>5040-3</TD><TD>14.04.2023</TD><TD>2</TD></TR><TR><TD>5038-4</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>4991-1</TD><TD>14.04.2023</TD><TD>1</TD></TR><TR><TD>492</TD><TD>14.04.2023</TD><TD>2</TD></TR><TR><TD>485</TD><TD>14.04.2023</TD><TD>8</TD></TR><TR><TD>4814</TD><TD>14.04.2023</TD><TD>84</TD></TR><TR><TD>478</TD><TD>14.04.2023</TD><TD>30</TD></TR><TR><TD>472</TD><TD>14.04.2023</TD><TD>2</TD></TR><TR><TD>471</TD><TD>14.04.2023</TD><TD>10</TD></TR><TR><TD>468</TD><TD>13.04.2023</TD><TD>10</TD></TR><TR><TD>467</TD><TD>13.04.2023</TD><TD>30</TD></TR><TR><TD>465</TD><TD>13.04.2023</TD><TD>10</TD></TR><TR><TD>4647</TD><TD>13.04.2023</TD><TD>24</TD></TR><TR><TD>4645</TD><TD>13.04.2023</TD><TD>48</TD></TR><TR><TD>4614</TD><TD>13.04.2023</TD><TD>10</TD></TR><TR><TD>4575</TD><TD>13.04.2023</TD><TD>2</TD></TR><TR><TD>4450</TD><TD>13.04.2023</TD><TD>5</TD></TR><TR><TD>4245</TD><TD>13.04.2023</TD><TD>12</TD></TR><TR><TD>4224</TD><TD>13.04.2023</TD><TD>10</TD></TR><TR><TD>4207-2</TD><TD>13.04.2023</TD><TD>1</TD></TR><TR><TD>4132</TD><TD>13.04.2023</TD><TD>10</TD></TR><TR><TD>4119</TD><TD>13.04.2023</TD><TD>5</TD></TR><TR><TD>3895</TD><TD>13.04.2023</TD><TD>8</TD></TR><TR><TD>3868</TD><TD>13.04.2023</TD><TD>4</TD></TR><TR><TD>3863</TD><TD>13.04.2023</TD><TD>6</TD></TR></TBODY></TABLE> Tue, 18 Apr 2023 11:55:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3193542#M115870 s_kula 2023-04-18T11:55:25Z Re: DAX finding dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3196826#M116087 <P>your sample data only contains one date per product id, so we cannot compute the penultimate date.</P> Thu, 20 Apr 2023 00:38:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3196826#M116087 lbendlin 2023-04-20T00:38:27Z Re: DAX finding dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3204253#M116643 <P>Hello, actually the data was wrong. I am pasting the corrected ones now.</P><P>In this list, the maximum date is 24/04/2023.<BR />However, I want to be able to calculate the next e.g.<BR />22/04/2023 (max-1) and another 17/04/2023 (max-2), i.e. subsequent dates in a decreasing sequence. The function must include a filter for a specific product id.</P><P>At the same time, the result of this function is supposed to be a filter to find other values ​​from a table row.<BR />e.g.<BR />date 22/04.2023 for product id 25, is to be a filter to the sales quantity for a given date and product id.</P><P>&nbsp;</P> Tue, 25 Apr 2023 05:37:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3204253#M116643 s_kula 2023-04-25T05:37:51Z Re: DAX finding dates https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3205056#M116703 <P>The data is still not good. There is no overlap.</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Tue, 25 Apr 2023 12:49:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DAX-finding-dates/m-p/3205056#M116703 lbendlin 2023-04-25T12:49:04Z