Forum Discussion
Previous Test Date
Super UserAnonymous , what are trying to do with help from previous date
you can use RANKX
RANX(all(PNRDailyAllocatedProduction),PNRDailyAllocatedProduction[Test Date])
if you need last date as column
new column = maxx( filter(PNRDailyAllocatedProduction,[Test Date]<earlier([Test Date])),[Test Date])
In case of measure refer my blog
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
I have filtered the table below to 2 days behind for data accuracy and production date = current well test date. As you can see in the table below each well that was tested on 12/21/2020 has been pulled and its corresponding oil test. Along with the previous test date (no matter how far back it was) and its corresponding oil test on that previous date. The best way to make sure you are pulling the right well information is to use the wells unique identifier (comp_sk) which is hidden in the table below. So in short I just need help with the syntax to pull the previous date per comp_sk that is < than the current test date over all production dates.