topic Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498235#M68992 <P>Try changing the data format to whole number and let me know if it works.<BR /><BR />Thanks,<BR />Sanket</P> Fri, 06 May 2022 09:31:31 GMT Anonymous 2022-05-06T09:31:31Z Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498109#M68986 <P><SPAN>Hi all&nbsp;</SPAN><BR /><BR /><SPAN>Please&nbsp; help me how to use PREVIOUSYEAR&nbsp; function with this data that not have date table , I really need previous year yields for making report , but I'm not expert in DAX , hope someone can help me&nbsp;</SPAN><BR /><SPAN>Thankyou, in advance</SPAN></P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Fri, 06 May 2022 08:48:32 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498109#M68986 firstch 2022-05-06T08:48:32Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498155#M68987 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="386752" data-lia-user-login="firstch" class="lia-mention lia-mention-user">firstch</a>&nbsp;.<BR />First create a Date column using your Year Column.<BR />Date=DATE([YearColumn],"01","01").<BR /><BR />Then create&nbsp; a measure for previous Year using PrevYear=PREVIOUSYEAR(DateColumn)<BR /><BR /><BR />Thanks,<BR />Sanket<BR /><BR />If this post helps, then mark it as <STRONG>Accept as Solution</STRONG> and give it a thumbs up.</P> Fri, 06 May 2022 09:08:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498155#M68987 Anonymous 2022-05-06T09:08:24Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498184#M68989 <P>Hi&nbsp;Anonymous</a>&nbsp; when i create date column it pop up me this</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P> Fri, 06 May 2022 09:16:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498184#M68989 firstch 2022-05-06T09:16:05Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498188#M68990 <P>What is that first parameter which you are passsing?<BR />You just need to pass your Year Column as your first parameter.<BR /><BR />Check your formula once.<BR />Thanks,<BR />Sanket</P> Fri, 06 May 2022 09:19:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498188#M68990 Anonymous 2022-05-06T09:19:23Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498211#M68991 <P>Anonymous</a>&nbsp; I passing year column that call 'ปี' but the data type format is text&nbsp;</P><P>Thanks&nbsp;<BR />First</P> Fri, 06 May 2022 09:25:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498211#M68991 firstch 2022-05-06T09:25:52Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498235#M68992 <P>Try changing the data format to whole number and let me know if it works.<BR /><BR />Thanks,<BR />Sanket</P> Fri, 06 May 2022 09:31:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498235#M68992 Anonymous 2022-05-06T09:31:31Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498242#M68994 <P>I believe you have some additional brackets at the end your formula, remove them.<BR />Try and write the formula from scratch.</P> Fri, 06 May 2022 09:33:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498242#M68994 Anonymous 2022-05-06T09:33:57Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498248#M68995 <P><img /></P><P>it doesn't work sir</P> Fri, 06 May 2022 09:35:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498248#M68995 firstch 2022-05-06T09:35:58Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498270#M68997 <P><img /></P> <P>&nbsp;Do you have this brackets in your DAX at the end?</P> Fri, 06 May 2022 09:38:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498270#M68997 Anonymous 2022-05-06T09:38:51Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498274#M68998 <P>this is my DAX</P><P><img /></P><P><img /></P><P>&nbsp;</P><P>this is my date column</P><P><img /></P><P>&nbsp;</P><P><BR /><BR /></P> Fri, 06 May 2022 09:39:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498274#M68998 firstch 2022-05-06T09:39:36Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498279#M68999 <P>Worked right?</P> Fri, 06 May 2022 09:41:03 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498279#M68999 Anonymous 2022-05-06T09:41:03Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498290#M69001 <P>its doesn't show the prevyear Yield sir</P><P><img /></P><P>&nbsp;</P> Fri, 06 May 2022 09:46:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498290#M69001 firstch 2022-05-06T09:46:56Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498311#M69004 <P>Why are you getting your year column values as 2557,2558..?<BR />Check that first because the data which you provided has year column values as 2020,2021,2022....</P> Fri, 06 May 2022 09:54:27 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498311#M69004 Anonymous 2022-05-06T09:54:27Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498322#M69005 <P>the data that i give is the example but this one is real data both are&nbsp; same structure sir</P> Fri, 06 May 2022 09:58:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498322#M69005 firstch 2022-05-06T09:58:08Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498602#M69016 <P>Can you share a .pbix with some sample data?<BR /><BR /></P> Fri, 06 May 2022 12:28:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2498602#M69016 Anonymous 2022-05-06T12:28:50Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2499804#M69082 <P>Hi,</P><P>&nbsp;</P><P>Since you do not have a "proper" date (ie day, month and year), why not just substract 1 to the year to get the previous one ?</P><P>With a formula like :</P><DIV><PRE><SPAN>Prev Year Value = </SPAN><BR /><SPAN>VAR</SPAN> <SPAN>CurrentYear</SPAN><SPAN> = </SPAN><SPAN>SELECTEDVALUE</SPAN><SPAN>( </SPAN><SPAN>TabDatas[Year]</SPAN><SPAN> )</SPAN><BR /><SPAN>RETURN</SPAN><BR /><SPAN>CALCULATE</SPAN><SPAN>( </SPAN><SPAN>SUM</SPAN><SPAN>( </SPAN><SPAN>TabDatas[Value]</SPAN><SPAN> ) , </SPAN><SPAN>TabDatas[Year]</SPAN><SPAN> = </SPAN><SPAN>CurrentYear</SPAN><SPAN> -</SPAN><SPAN>1</SPAN><SPAN> )</SPAN></PRE><DIV><SPAN>and get that :</SPAN></DIV><DIV><SPAN><img /></SPAN></DIV><DIV><SPAN>If your data are as simple as the one shown, you might not need to use Time Intelligence functions. If you want to use them then you should create a proper date columns and maybe even a date table.</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Hope it helps</SPAN></DIV></DIV> Sat, 07 May 2022 11:28:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2499804#M69082 AilleryO 2022-05-07T11:28:34Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500119#M69102 <P>ok i willl share it please wait .</P><P>&nbsp;</P> Sun, 08 May 2022 08:29:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500119#M69102 firstch 2022-05-08T08:29:48Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500179#M69107 <P>how to share pbix file</P> Sun, 08 May 2022 10:49:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500179#M69107 firstch 2022-05-08T10:49:24Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500230#M69110 <P>Anonymous</a>&nbsp; want this as output</P><P><img /></P><P>this is all data</P><TABLE><TBODY><TR><TD>product</TD><TD>year</TD><TD>yields_tons</TD><TD>harvest_area_SQM</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>138,520</TD><TD>81,543</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>76,009</TD><TD>46,512</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>23,722</TD><TD>33,364</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>19,906</TD><TD>34,440</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>14,928</TD><TD>9,434</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>11,433</TD><TD>27,028</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>8,296</TD><TD>5,169</TD></TR><TR><TD>cabbage</TD><TD>2563</TD><TD>2,888</TD><TD>5,618</TD></TR><TR><TD>cabbage</TD><TD>2564</TD><TD>2,819</TD><TD>3,747</TD></TR><TR><TD>cabbage</TD><TD>2564</TD><TD>2,708</TD><TD>4,147</TD></TR><TR><TD>carrot</TD><TD>2564</TD><TD>242,686</TD><TD>167,504</TD></TR><TR><TD>carrot</TD><TD>2564</TD><TD>130,918</TD><TD>107,222</TD></TR><TR><TD>carrot</TD><TD>2564</TD><TD>75,731</TD><TD>54,840</TD></TR><TR><TD>carrot</TD><TD>2564</TD><TD>33,133</TD><TD>38,298</TD></TR><TR><TD>carrot</TD><TD>2564</TD><TD>30,220</TD><TD>23,580</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>30,007</TD><TD>43,806</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>1,150</TD><TD>2,208</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>1,084</TD><TD>3,576</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>1,077</TD><TD>2,613</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>893</TD><TD>2,249</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>451</TD><TD>567</TD></TR><TR><TD>carrot</TD><TD>2565</TD><TD>301</TD><TD>435</TD></TR><TR><TD>tomato</TD><TD>2562</TD><TD>260</TD><TD>348</TD></TR><TR><TD>tomato</TD><TD>2562</TD><TD>219</TD><TD>328</TD></TR><TR><TD>tomato</TD><TD>2562</TD><TD>192</TD><TD>295</TD></TR><TR><TD>tomato</TD><TD>2557</TD><TD>160</TD><TD>140</TD></TR><TR><TD>tomato</TD><TD>2557</TD><TD>40</TD><TD>68</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>234,514</TD><TD>167,004</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>124,495</TD><TD>108,257</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>71,182</TD><TD>55,192</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>31,922</TD><TD>23,155</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>30,809</TD><TD>37,815</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>28,850</TD><TD>23,283</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>24,965</TD><TD>44,163</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>9,416</TD><TD>30,852</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>7,924</TD><TD>28,655</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>6,982</TD><TD>5,066</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>6,192</TD><TD>8,878</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>4,522</TD><TD>14,309</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>4,104</TD><TD>8,390</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>3,394</TD><TD>3,470</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>3,259</TD><TD>7,250</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>1,633</TD><TD>1,638</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>1,175</TD><TD>2,202</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>1,045</TD><TD>3,537</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>972</TD><TD>1,449</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>823</TD><TD>2,228</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>773</TD><TD>2,082</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>577</TD><TD>1,953</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>373</TD><TD>631</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>326</TD><TD>454</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>267</TD><TD>430</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>240</TD><TD>354</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>165</TD><TD>167</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>78</TD><TD>170</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>39</TD><TD>72</TD></TR><TR><TD>carrot</TD><TD>2558</TD><TD>1</TD><TD>19</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>187,790</TD><TD>171,092</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>119,814</TD><TD>127,250</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>59,676</TD><TD>56,234</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>30,393</TD><TD>37,929</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>29,904</TD><TD>24,178</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>463</TD><TD>2,238</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>251</TD><TD>646</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>187</TD><TD>536</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>177</TD><TD>442</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>138</TD><TD>5,056</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>119</TD><TD>126</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>52</TD><TD>182</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>49</TD><TD>395</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>34</TD><TD>87</TD></TR><TR><TD>carrot</TD><TD>2559</TD><TD>1</TD><TD>26</TD></TR><TR><TD>carrot</TD><TD>2560</TD><TD>284,874</TD><TD>173,672</TD></TR><TR><TD>carrot</TD><TD>2560</TD><TD>114,252</TD><TD>130,911</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>102,908</TD><TD>126,688</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>48,366</TD><TD>80,088</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>38,356</TD><TD>54,405</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>23,931</TD><TD>32,177</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>16,710</TD><TD>23,656</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>10,559</TD><TD>13,894</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>10,270</TD><TD>12,918</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>8,895</TD><TD>12,387</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>8,342</TD><TD>20,546</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>6,895</TD><TD>11,259</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>4,049</TD><TD>4,855</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>2,078</TD><TD>7,318</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>1,685</TD><TD>3,187</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>1,627</TD><TD>2,815</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>1,381</TD><TD>2,019</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>971</TD><TD>1,317</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>624</TD><TD>886</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>484</TD><TD>918</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>483</TD><TD>1,189</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>406</TD><TD>652</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>247</TD><TD>449</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>96</TD><TD>278</TD></TR><TR><TD>grape</TD><TD>2557</TD><TD>11</TD><TD>43</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>81,660</TD><TD>127,594</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>31,124</TD><TD>79,359</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>18,395</TD><TD>33,782</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>14,264</TD><TD>26,231</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>13,260</TD><TD>54,119</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>6,974</TD><TD>12,670</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>6,215</TD><TD>19,883</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>5,866</TD><TD>13,858</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>5,192</TD><TD>11,800</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>4,787</TD><TD>12,106</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>3,213</TD><TD>6,933</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>2,676</TD><TD>4,613</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>1,266</TD><TD>2,610</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>1,151</TD><TD>3,059</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>1,043</TD><TD>1,989</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>660</TD><TD>1,246</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>659</TD><TD>1,039</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>462</TD><TD>895</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>392</TD><TD>1,109</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>296</TD><TD>638</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>246</TD><TD>449</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>98</TD><TD>305</TD></TR><TR><TD>grape</TD><TD>2558</TD><TD>12</TD><TD>43</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>68,871</TD><TD>129,339</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>29,150</TD><TD>80,126</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>25,226</TD><TD>54,308</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>15,649</TD><TD>34,917</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>13,191</TD><TD>26,258</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>5,952</TD><TD>20,626</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>5,943</TD><TD>12,670</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>5,279</TD><TD>13,945</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>4,280</TD><TD>11,974</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>4,106</TD><TD>11,774</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>2,793</TD><TD>6,621</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>2,472</TD><TD>4,490</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>1,119</TD><TD>2,534</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>831</TD><TD>2,924</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>589</TD><TD>1,161</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>462</TD><TD>895</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>450</TD><TD>1,475</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>434</TD><TD>1,404</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>249</TD><TD>599</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>118</TD><TD>449</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>100</TD><TD>493</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>91</TD><TD>343</TD></TR><TR><TD>grape</TD><TD>2559</TD><TD>12</TD><TD>43</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>112,309</TD><TD>129,537</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>24,897</TD><TD>81,097</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>24,603</TD><TD>35,047</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>16,766</TD><TD>26,204</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>13,899</TD><TD>52,449</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>4,878</TD><TD>13,780</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>3,304</TD><TD>9,982</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>3,237</TD><TD>12,367</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>1,388</TD><TD>4,271</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>698</TD><TD>2,948</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>683</TD><TD>1,369</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>638</TD><TD>2,292</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>610</TD><TD>12,218</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>327</TD><TD>1,447</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>318</TD><TD>6,621</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>294</TD><TD>1,429</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>281</TD><TD>599</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>277</TD><TD>503</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>194</TD><TD>518</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>96</TD><TD>340</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>85</TD><TD>20,225</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>83</TD><TD>449</TD></TR><TR><TD>grape</TD><TD>2560</TD><TD>15</TD><TD>60</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>50,719</TD><TD>129,807</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>40,240</TD><TD>83,713</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>24,095</TD><TD>49,815</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>14,583</TD><TD>36,675</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>11,399</TD><TD>20,307</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>8,291</TD><TD>13,615</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>8,274</TD><TD>27,141</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>6,642</TD><TD>12,247</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>5,787</TD><TD>12,871</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>4,757</TD><TD>10,697</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>3,307</TD><TD>6,861</TD></TR><TR><TD>grape</TD><TD>2561</TD><TD>2,330</TD><TD>4,052</TD></TR></TBODY></TABLE><P>Thankyou in advance&nbsp;Anonymous</a>&nbsp;<BR /><BR /></P><P>firstch</P> Sun, 08 May 2022 13:06:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500230#M69110 firstch 2022-05-08T13:06:48Z Re: Is it possible to use PRREVIOUSYEAR FUNCTION with this data? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500245#M69111 <P>Hi,</P><P>&nbsp;</P><P>Here is the solution calculated witha measure :</P><DIV><PRE><SPAN>Measure PrevYear = </SPAN></PRE><PRE><SPAN>VAR CurrentYear = SELECTEDVALUE( DataHarvest[year] )<BR />RETURN<BR />CALCULATE( SUM( DataHarvest[yields_tons] ) , DataHarvest[Year]=CurrentYear-1 )</SPAN></PRE><DIV><SPAN>to get that :</SPAN></DIV><DIV><SPAN><img /></SPAN></DIV></DIV> Sun, 08 May 2022 13:38:00 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Is-it-possible-to-use-PRREVIOUSYEAR-FUNCTION-with-this-data/m-p/2500245#M69111 AilleryO 2022-05-08T13:38:00Z