Forum Discussion
Finding latest value based on date
Hi everyone! I have a data set (CheckUP) which contains all the check up meetings I have had with several employees. It is a monthly thing so I collect the answers and then refresh the source fil...
I did not notice v-eachen-msft, thank you for clarifying that issue. Would you by any chance know how I could change this so it would work with my dataset?
So I managed to get a filter that returns true/false and based on that I can filter out the falses and keep only the latest date, however I have 2 types of subject: visit and call and I want to know the latest date for both subject types.
This column is what I am currently using:
LatestDate = report1588859888847[End Date] =
CALCULATE(
MAX(report1588859888847[End Date]),
FILTER(ALL(report1588859888847), report1588859888847[Person name]=EARLIER(report1588859888847[Person name]))
)
Is there a way somehow to make it check for the subject type too or have another column added that also checks for subject type so I can use that as a filter/slicer?