https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1972859#M43361 <LI-CODE lang="csharp">[Previous Date] = // calculated column in table T var CurrentDate = T[Date] var PreviousDate = MAXX( TOPN(1, FILTER( DISTINCT( T[Date] ), T[Date] &lt; CurrentDate ), T[Date], DESC ), T[Date] ) return PreviousDate</LI-CODE><P>Might be what you want... but I have not opened the file since my company policy forbids it.</P> Thu, 22 Jul 2021 10:04:59 GMT Anonymous 2021-07-22T10:04:59Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1969991#M43241 <P>I want to get some data within the same table where the date is the last date within the previous reporting period. All this is doing is allowing me to track progress of columns since the previous reporting period (normally around a month). I've included a workbook with the current table in one tab and the desired in the other. To get the desired I just found the 'Review Count' from 32 rows above and took it away from the current row Review Count, but this won't work once filtered.&nbsp;</P><P>&nbsp;</P><P><A href="https://jmservicescomau-my.sharepoint.com/:x:/g/personal/jacob_jmservices_com_au/ET1aZvrVTC9GjMvpiLwOz_wBmIFAJ2lpgIV2vKIcSDrVYw?e=6wHI28" target="_self">Book2</A>&nbsp;</P> Wed, 21 Jul 2021 07:47:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1969991#M43241 JollyRoger01 2021-07-21T07:47:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1971101#M43316 <P>Please note that if you don't get answers for a long time, it means people don't understand your description. If you want to know what to do to get your questions answered quickly...&nbsp;<A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-p/1626726" target="_blank" rel="noopener">How to Get Your Question Answered Quickly - Microsoft Power BI Community</A></P> Wed, 21 Jul 2021 18:19:30 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1971101#M43316 Anonymous 2021-07-21T18:19:30Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1971446#M43327 <P>After reading my original question I've realised the description was a little vague and confusing so I've tried to make it a bit easier to follow. Below is a workbook showing what I am actually after. I am trying to retrieve the last date in a column that is less than the date of the current row being evaluated. I am not sure how to evaluate the current row and an entire column at the same time.</P><P>&nbsp;</P><P><A href="https://jmservicescomau-my.sharepoint.com/:x:/g/personal/jacob_jmservices_com_au/Eb3t73Y3KhlBpww1vOsuzhUBAjZDlgp5jz56bQkOvGxhWA?e=3hFFxo" target="_self">Example</A>&nbsp;</P> Thu, 22 Jul 2021 01:47:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1971446#M43327 JollyRoger01 2021-07-22T01:47:37Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1972859#M43361 <LI-CODE lang="csharp">[Previous Date] = // calculated column in table T var CurrentDate = T[Date] var PreviousDate = MAXX( TOPN(1, FILTER( DISTINCT( T[Date] ), T[Date] &lt; CurrentDate ), T[Date], DESC ), T[Date] ) return PreviousDate</LI-CODE><P>Might be what you want... but I have not opened the file since my company policy forbids it.</P> Thu, 22 Jul 2021 10:04:59 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Get-value-from-column-where-date-is-max-latest-and-is-prior-to/m-p/1972859#M43361 Anonymous 2021-07-22T10:04:59Z