Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

LASTDATE by Record ID

We're trying to find out the last time an Activity was created for each ID in a set of records.   Each Lead has an ID and, if contacted, various activities at different times like this:    ...
Need Help
  • ankitpatira's avatar
    ankitpatira
    9 years ago

    Anonymous In power bi desktop go to query editor (Edit Queries), right click your query and duplicate. Then to the duplicated query under Transform tab -> Group by as shown below. Finally Close&Apply and ensure there is active relationship between lead id columns of both the tables. Then use table visual and use leadid,activity from the duplicated columns and other columns from your original query and you will get the desired output.

     

ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

Anonymous In power bi desktop go to query editor (Edit Queries), right click your query and duplicate. Then to the duplicated query under Transform tab -> Group by as shown below. Finally Close&Apply and ensure there is active relationship between lead id columns of both the tables. Then use table visual and use leadid,activity from the duplicated columns and other columns from your original query and you will get the desired output.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

That is awesome.  Thank you so much.