https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-Maximum-Available-date-and-the-date-before-it/m-p/3382185#M127443 <P>hello why is 15 august your max date? do you mean by todays date? like today is 16 august and you need also the value of 15 august?</P> Wed, 16 Aug 2023 07:50:39 GMT eliasayyy 2023-08-16T07:50:39Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-Maximum-Available-date-and-the-date-before-it/m-p/3382120#M127442 <P>Hi everyone! May I ask for your help guys? Thanks!<BR /><BR />I have a scenario here wherein I need to compute for the 2 latest available in the column that I'll be using as my:<BR />1. Beginning Value&nbsp;<BR />2. Ending Value</P><P><img /></P><P><BR />Above image is showing that Aug 15 with the value of <STRONG>194,581&nbsp;</STRONG>is my latest available date, having said that, I need this 194,581 to be my <STRONG>Ending Value</STRONG> and Aug 14&nbsp;<STRONG>225,936</STRONG> to be my <STRONG>Beginning Value</STRONG>. So this logic has to be applied until the end of the month as the values change each day, meaning my Beginning and Ending values will change accordingly.<BR /><BR />Note: This Ending_Test1 measure is filling the blank dates with the last non-blank value up to the next available date that has data.<BR /><BR />Many Thanks!</P><P><BR /><BR /></P> Wed, 16 Aug 2023 07:19:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-Maximum-Available-date-and-the-date-before-it/m-p/3382120#M127442 puffc0rn 2023-08-16T07:19:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-Maximum-Available-date-and-the-date-before-it/m-p/3382185#M127443 <P>hello why is 15 august your max date? do you mean by todays date? like today is 16 august and you need also the value of 15 august?</P> Wed, 16 Aug 2023 07:50:39 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-the-Maximum-Available-date-and-the-date-before-it/m-p/3382185#M127443 eliasayyy 2023-08-16T07:50:39Z