Forum Discussion
Solved
Latest Date Filter
I have seen many solutions to this problem, but none of them seem to work for my dataset. I have a table listing property names, codes, area, and area date. I'd like to filter my table to only show o...
Hi,
Write this calculated column formula
=if(Data[Date]=max(Data[Date]),1,0)
Hope this helps.
My data is over 100,000 rows and that doesn't return results in finite time, I'm afraid. I've bookmarked the solution in this thread, which works quickly. Thanks.
Solved: Finding the most recent value - Microsoft Power BI Community
The solution is by CheenuSing on March 14, 2018 at 8:40 pm.