topic Re: Need Urgent Help to fix this dax measure in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713614#M180537 <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>not sure if i really get you, try to add a calculated column like:</P> <LI-CODE lang="markup">PD Date = VAR _leftover = SUMX( FILTER( data, data[markets] = EARLIER(data[markets]) &amp;&amp;data[max of eta] &lt; EARLIER(data[max of eta]) ), [count of container number] - [Capacity] ) VAR _result = IF( _leftover+[count of container number] &gt; [capacity], [max of eta] + [clearence days]+1, [max of eta] + [clearence days] ) RETURN _result</LI-CODE> <P>&nbsp;</P> <P>it worked like:</P> <P><img /></P> <P>&nbsp;</P> Fri, 30 May 2025 08:29:04 GMT FreemanZ 2025-05-30T08:29:04Z Need Urgent Help to fix this dax measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713518#M180532 <P>Hi Team</P><P>I need your help to calculate the<SPAN>&nbsp;</SPAN><STRONG>PD Date</STRONG><SPAN>&nbsp;</SPAN>using the following logic:</P><OL><LI><P><STRONG>For each day</STRONG>:</P><UL><LI>If the<SPAN>&nbsp;</SPAN><STRONG>total number of containers</STRONG><SPAN>&nbsp;</SPAN>for that day is<SPAN>&nbsp;</SPAN><STRONG>more than the allowed capacity</STRONG>, then:<UL><LI><STRONG>PD Date</STRONG><SPAN>&nbsp;</SPAN>= Max ETA + Clearance Days + 1</LI></UL></LI><LI>If it's<SPAN>&nbsp;</SPAN><STRONG>within the capacity</STRONG>, then:<UL><LI><STRONG>PD Date</STRONG><SPAN>&nbsp;</SPAN>= Max ETA + Clearance Days</LI></UL></LI></UL></LI><LI><P><STRONG>This check should continue daily</STRONG>, and also consider:</P><UL><LI>If the<SPAN>&nbsp;</SPAN><STRONG>containers left from the previous day</STRONG><SPAN>&nbsp;</SPAN>plus<SPAN>&nbsp;</SPAN><STRONG>today’s containers</STRONG><SPAN>&nbsp;</SPAN>are more than the capacity, then:<UL><LI><STRONG>PD Date</STRONG><SPAN>&nbsp;</SPAN>= Max ETA + Clearance Days + 1</LI></UL></LI><LI>Otherwise:<UL><LI><STRONG>PD Date</STRONG><SPAN>&nbsp;</SPAN>= Max ETA + Clearance Days</LI></UL></LI></UL></LI></OL><P>Could you please help me apply this logic and get the correct PD Dates?</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 30 May 2025 07:37:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713518#M180532 tkavitha911 2025-05-30T07:37:56Z Re: Need Urgent Help to fix this dax measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713541#M180533 <TABLE><TBODY><TR><TD>Markets</TD><TD>Supply Category</TD><TD>Max of ETA</TD><TD>Count of Container Number</TD><TD>Capacity</TD><TD>Clearence days</TD></TR><TR><TD>China</TD><TD>02 MTO</TD><TD>01-01-2025 00:00</TD><TD>1</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>06-01-2025 00:00</TD><TD>11</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>07-01-2025 00:00</TD><TD>12</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>02 MTO</TD><TD>07-01-2025 00:00</TD><TD>10</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>10-01-2025 00:00</TD><TD>27</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>02 MTO</TD><TD>10-01-2025 00:00</TD><TD>2</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>13-01-2025 00:00</TD><TD>1</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>14-01-2025 00:00</TD><TD>6</TD><TD>8</TD><TD>3</TD></TR><TR><TD>China</TD><TD>01 SMR</TD><TD>18-01-2025 00:00</TD><TD>10</TD><TD>8</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>01-01-2025 00:00</TD><TD>1</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>02-01-2025 00:00</TD><TD>64</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>03-01-2025 00:00</TD><TD>1</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>05-01-2025 00:00</TD><TD>2</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>08-02-2025 00:00</TD><TD>37</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>09-02-2025 00:00</TD><TD>1</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>10-02-2025 00:00</TD><TD>1</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>11-02-2025 00:00</TD><TD>2</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>12-02-2025 00:00</TD><TD>2</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>01 SMR</TD><TD>14-02-2025 00:00</TD><TD>7</TD><TD>6</TD><TD>3</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>23-01-2025 00:00</TD><TD>23</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>01 SMR</TD><TD>24-01-2025 00:00</TD><TD>3</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>01 SMR</TD><TD>25-01-2025 00:00</TD><TD>1</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>25-01-2025 00:00</TD><TD>4</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>26-01-2025 00:00</TD><TD>1</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>27-01-2025 00:00</TD><TD>1</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>01 SMR</TD><TD>30-01-2025 00:00</TD><TD>1</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>31-01-2025 00:00</TD><TD>1</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Japan</TD><TD>02 MTO</TD><TD>02-02-2025 00:00</TD><TD>5</TD><TD>2</TD><TD>4</TD></TR><TR><TD>Korea</TD><TD>01 SMR</TD><TD>31-01-2025 00:00</TD><TD>4</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>02 MTO</TD><TD>01-02-2025 00:00</TD><TD>10</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>01 SMR</TD><TD>03-02-2025 00:00</TD><TD>5</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>02 MTO</TD><TD>03-02-2025 00:00</TD><TD>1</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>02 MTO</TD><TD>07-02-2025 00:00</TD><TD>1</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>02 MTO</TD><TD>11-02-2025 00:00</TD><TD>5</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Korea</TD><TD>01 SMR</TD><TD>28-02-2025 00:00</TD><TD>3</TD><TD>10</TD><TD>3</TD></TR><TR><TD>Australia</TD><TD>02 MTO</TD><TD>06-01-2025 00:00</TD><TD>1</TD><TD>6</TD><TD>3</TD></TR></TBODY></TABLE> Fri, 30 May 2025 07:46:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713541#M180533 tkavitha911 2025-05-30T07:46:32Z Re: Need Urgent Help to fix this dax measure https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713614#M180537 <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>not sure if i really get you, try to add a calculated column like:</P> <LI-CODE lang="markup">PD Date = VAR _leftover = SUMX( FILTER( data, data[markets] = EARLIER(data[markets]) &amp;&amp;data[max of eta] &lt; EARLIER(data[max of eta]) ), [count of container number] - [Capacity] ) VAR _result = IF( _leftover+[count of container number] &gt; [capacity], [max of eta] + [clearence days]+1, [max of eta] + [clearence days] ) RETURN _result</LI-CODE> <P>&nbsp;</P> <P>it worked like:</P> <P><img /></P> <P>&nbsp;</P> Fri, 30 May 2025 08:29:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-Urgent-Help-to-fix-this-dax-measure/m-p/4713614#M180537 FreemanZ 2025-05-30T08:29:04Z