Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

In your dataset table above, I find that the "CheckUP[general view details]" is text type. If you use SUM() function on this field, it will return an error.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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?