cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrainey Member
Member

Show Only Latest Record

Given this formula/table:

1.PNG
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:

1.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Show Only Latest Record

Hi @mrainey,

 

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.

 

 

Latest date.png

 

 

 

2 REPLIES 2
Anonymous
Not applicable

Re: Show Only Latest Record

Hi @mrainey,

 

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.

 

 

Latest date.png

 

 

 

Anonymous
Not applicable

Re: Show Only Latest Record

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