topic How to get value comparing the max and min stock prices in DAX Commands and Tips

topic How to get value comparing the max and min stock prices in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-value-comparing-the-max-and-min-stock-prices/m-p/1250889#M20599 <P>Hello everyone,</P><P> </P><P>There is a table of the NY Dow stock prices for the last 1 month.</P><P>I want to get  a date when the min price falls more than 15% from the max price in the last 1 month.</P><P>How should it be calculated with DAX?<BR /><BR /></P><P><A href="https://jp.investing.com/indices/us-30-historical-data" target="_blank" rel="noopener">https://jp.investing.com/indices/us-30-historical-data</A></P><P> </P><TABLE><TBODY><TR><TD>Date  </TD><TD>Close</TD><TD>Start</TD><TD>High</TD><TD>Low</TD><TD>Volume</TD><TD>Comparison with the previous day%</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>2020/7/24  </TD><TD>26,469.89  </TD><TD>26,533.41  </TD><TD>26,625.70  </TD><TD>26,402.86  </TD><TD>497.97M  </TD><TD>-0.68%</TD></TR><TR><TD>2020/7/23</TD><TD>26,652.33</TD><TD>26,955.97</TD><TD>26,973.85</TD><TD>26,560.04</TD><TD>426.56M</TD><TD>-1.31%</TD></TR><TR><TD>2020/7/22</TD><TD>27,005.84</TD><TD>26,824.56</TD><TD>27,035.24</TD><TD>26,794.19</TD><TD>410.82M</TD><TD>0.62%</TD></TR><TR><TD>2020/7/21</TD><TD>26,840.40</TD><TD>26,833.14</TD><TD>27,025.38</TD><TD>26,766.22</TD><TD>367.24M</TD><TD>0.60%</TD></TR><TR><TD>2020/7/20</TD><TD>26,680.87</TD><TD>26,660.29</TD><TD>26,765.02</TD><TD>26,504.20</TD><TD>312.07M</TD><TD>0.03%</TD></TR><TR><TD>2020/7/17</TD><TD>26,671.95</TD><TD>26,774.62</TD><TD>26,808.43</TD><TD>26,619.88</TD><TD>300.52M</TD><TD>-0.23%</TD></TR><TR><TD>2020/7/16</TD><TD>26,734.71</TD><TD>26,746.57</TD><TD>26,879.16</TD><TD>26,590.01</TD><TD>288.04M</TD><TD>-0.50%</TD></TR><TR><TD>2020/7/15</TD><TD>26,870.10</TD><TD>27,009.81</TD><TD>27,071.33</TD><TD>26,692.48</TD><TD>388.26M</TD><TD>0.85%</TD></TR><TR><TD>2020/7/14</TD><TD>26,642.59</TD><TD>26,044.17</TD><TD>26,690.52</TD><TD>25,994.98</TD><TD>407.34M</TD><TD>2.13%</TD></TR><TR><TD>2020/7/13</TD><TD>26,085.80</TD><TD>26,225.07</TD><TD>26,639.09</TD><TD>26,044.23</TD><TD>428.57M</TD><TD>0.04%</TD></TR><TR><TD>2020/7/10</TD><TD>26,075.30</TD><TD>25,690.35</TD><TD>26,101.32</TD><TD>25,637.50</TD><TD>337.36M</TD><TD>1.44%</TD></TR><TR><TD>2020/7/9</TD><TD>25,706.09</TD><TD>26,094.92</TD><TD>26,103.28</TD><TD>25,523.51</TD><TD>389.18M</TD><TD>-1.39%</TD></TR><TR><TD>2020/7/8</TD><TD>26,067.28</TD><TD>25,950.06</TD><TD>26,109.49</TD><TD>25,816.25</TD><TD>337.30M</TD><TD>0.68%</TD></TR><TR><TD>2020/7/7</TD><TD>25,890.18</TD><TD>26,172.01</TD><TD>26,174.93</TD><TD>25,866.58</TD><TD>349.00M</TD><TD>-1.51%</TD></TR><TR><TD>2020/7/6</TD><TD>26,287.03</TD><TD>25,996.08</TD><TD>26,297.53</TD><TD>25,996.08</TD><TD>342.26M</TD><TD>1.78%</TD></TR><TR><TD>2020/7/2</TD><TD>25,827.36</TD><TD>25,936.45</TD><TD>26,204.41</TD><TD>25,778.12</TD><TD>350.29M</TD><TD>0.36%</TD></TR><TR><TD>2020/7/1</TD><TD>25,734.97</TD><TD>25,879.38</TD><TD>26,019.31</TD><TD>25,713.61</TD><TD>373.98M</TD><TD>-0.30%</TD></TR><TR><TD>2020/6/30</TD><TD>25,812.88</TD><TD>25,512.43</TD><TD>25,905.38</TD><TD>25,475.14</TD><TD>412.69M</TD><TD>0.85%</TD></TR><TR><TD>2020/6/29</TD><TD>25,595.80</TD><TD>25,152.45</TD><TD>25,601.15</TD><TD>25,096.16</TD><TD>385.13M</TD><TD>2.32%</TD></TR><TR><TD>2020/6/26</TD><TD>25,015.55</TD><TD>25,641.69</TD><TD>25,641.69</TD><TD>24,971.03</TD><TD>676.18M</TD><TD>-2.84%</TD></TR></TBODY></TABLE><P><BR />Thanks for your help,<BR />Vladi</P> Sun, 26 Jul 2020 14:09:51 GMT PbiCeo 2020-07-26T14:09:51Z How to get value comparing the max and min stock prices https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-value-comparing-the-max-and-min-stock-prices/m-p/1250889#M20599 <P>Hello everyone,</P><P> </P><P>There is a table of the NY Dow stock prices for the last 1 month.</P><P>I want to get  a date when the min price falls more than 15% from the max price in the last 1 month.</P><P>How should it be calculated with DAX?<BR /><BR /></P><P><A href="https://jp.investing.com/indices/us-30-historical-data" target="_blank" rel="noopener">https://jp.investing.com/indices/us-30-historical-data</A></P><P> </P><TABLE><TBODY><TR><TD>Date  </TD><TD>Close</TD><TD>Start</TD><TD>High</TD><TD>Low</TD><TD>Volume</TD><TD>Comparison with the previous day%</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD>2020/7/24  </TD><TD>26,469.89  </TD><TD>26,533.41  </TD><TD>26,625.70  </TD><TD>26,402.86  </TD><TD>497.97M  </TD><TD>-0.68%</TD></TR><TR><TD>2020/7/23</TD><TD>26,652.33</TD><TD>26,955.97</TD><TD>26,973.85</TD><TD>26,560.04</TD><TD>426.56M</TD><TD>-1.31%</TD></TR><TR><TD>2020/7/22</TD><TD>27,005.84</TD><TD>26,824.56</TD><TD>27,035.24</TD><TD>26,794.19</TD><TD>410.82M</TD><TD>0.62%</TD></TR><TR><TD>2020/7/21</TD><TD>26,840.40</TD><TD>26,833.14</TD><TD>27,025.38</TD><TD>26,766.22</TD><TD>367.24M</TD><TD>0.60%</TD></TR><TR><TD>2020/7/20</TD><TD>26,680.87</TD><TD>26,660.29</TD><TD>26,765.02</TD><TD>26,504.20</TD><TD>312.07M</TD><TD>0.03%</TD></TR><TR><TD>2020/7/17</TD><TD>26,671.95</TD><TD>26,774.62</TD><TD>26,808.43</TD><TD>26,619.88</TD><TD>300.52M</TD><TD>-0.23%</TD></TR><TR><TD>2020/7/16</TD><TD>26,734.71</TD><TD>26,746.57</TD><TD>26,879.16</TD><TD>26,590.01</TD><TD>288.04M</TD><TD>-0.50%</TD></TR><TR><TD>2020/7/15</TD><TD>26,870.10</TD><TD>27,009.81</TD><TD>27,071.33</TD><TD>26,692.48</TD><TD>388.26M</TD><TD>0.85%</TD></TR><TR><TD>2020/7/14</TD><TD>26,642.59</TD><TD>26,044.17</TD><TD>26,690.52</TD><TD>25,994.98</TD><TD>407.34M</TD><TD>2.13%</TD></TR><TR><TD>2020/7/13</TD><TD>26,085.80</TD><TD>26,225.07</TD><TD>26,639.09</TD><TD>26,044.23</TD><TD>428.57M</TD><TD>0.04%</TD></TR><TR><TD>2020/7/10</TD><TD>26,075.30</TD><TD>25,690.35</TD><TD>26,101.32</TD><TD>25,637.50</TD><TD>337.36M</TD><TD>1.44%</TD></TR><TR><TD>2020/7/9</TD><TD>25,706.09</TD><TD>26,094.92</TD><TD>26,103.28</TD><TD>25,523.51</TD><TD>389.18M</TD><TD>-1.39%</TD></TR><TR><TD>2020/7/8</TD><TD>26,067.28</TD><TD>25,950.06</TD><TD>26,109.49</TD><TD>25,816.25</TD><TD>337.30M</TD><TD>0.68%</TD></TR><TR><TD>2020/7/7</TD><TD>25,890.18</TD><TD>26,172.01</TD><TD>26,174.93</TD><TD>25,866.58</TD><TD>349.00M</TD><TD>-1.51%</TD></TR><TR><TD>2020/7/6</TD><TD>26,287.03</TD><TD>25,996.08</TD><TD>26,297.53</TD><TD>25,996.08</TD><TD>342.26M</TD><TD>1.78%</TD></TR><TR><TD>2020/7/2</TD><TD>25,827.36</TD><TD>25,936.45</TD><TD>26,204.41</TD><TD>25,778.12</TD><TD>350.29M</TD><TD>0.36%</TD></TR><TR><TD>2020/7/1</TD><TD>25,734.97</TD><TD>25,879.38</TD><TD>26,019.31</TD><TD>25,713.61</TD><TD>373.98M</TD><TD>-0.30%</TD></TR><TR><TD>2020/6/30</TD><TD>25,812.88</TD><TD>25,512.43</TD><TD>25,905.38</TD><TD>25,475.14</TD><TD>412.69M</TD><TD>0.85%</TD></TR><TR><TD>2020/6/29</TD><TD>25,595.80</TD><TD>25,152.45</TD><TD>25,601.15</TD><TD>25,096.16</TD><TD>385.13M</TD><TD>2.32%</TD></TR><TR><TD>2020/6/26</TD><TD>25,015.55</TD><TD>25,641.69</TD><TD>25,641.69</TD><TD>24,971.03</TD><TD>676.18M</TD><TD>-2.84%</TD></TR></TBODY></TABLE><P><BR />Thanks for your help,<BR />Vladi</P> Sun, 26 Jul 2020 14:09:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-value-comparing-the-max-and-min-stock-prices/m-p/1250889#M20599 PbiCeo 2020-07-26T14:09:51Z Re: How to get value comparing the max and min stock prices https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-value-comparing-the-max-and-min-stock-prices/m-p/1250897#M20600 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="231641" data-lia-user-login="PbiCeo" class="lia-mention lia-mention-user">PbiCeo</a> - Well, you could create a calculated column and use EARLIER. See my article on Mean Time Between Failure (MTBF) which uses EARLIER: <A href="http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586" target="_blank">http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586</A></P> Sun, 26 Jul 2020 14:18:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-get-value-comparing-the-max-and-min-stock-prices/m-p/1250897#M20600 Greg_Deckler 2020-07-26T14:18:10Z