Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 to always pull from that value. The month & year column came from:



General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

     

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

     

     

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Similar issue, but once again this does not work on SSAS MD models.