Forum Discussion
Show Only Latest Record
Given this formula/table: How can I set up my formula to only return the value for the latest month & year? The month & year column will update as each month progresses so I need the formula...
Hi Anonymous,
In the fields, right click on the Revenue Date and select latest (screenshot attached). If your Revenue date is in date format, it should work.
Hi Anonymous,
In the fields, right click on the Revenue Date and select latest (screenshot attached). If your Revenue date is in date format, it should work.
Similar issue, but once again this does not work on SSAS MD models.