how to filter data to show activity Not in last 60 days

[gavin007]

Hi, I want to run a Salesforce report in PBI to show lapse lead for more than 60 days. The relative date filter will only show lead in the last 60 days, but i want the other way around, being active lead for more than 60 days. 

[gavin007]

I figure out a field call Day_since_last_activity in salesforece that i can use it it filter it. It works well. Thank you.

[v-yingjl]

Hi @gavin007 ,

Glad to hear the issue is solved. You can accept your reply as solution, that way, other community members could easily find the answer when they get same issues.

Best Regards,
Yingjie Li

[v-yingjl]

Hi @gavin007 ,

Maybe you can refer this issue:

How to show data of users don`t active in the last 30 days? 

If not help, could you please consider providing a dummy .pbix or expected output for further discussion?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@gavin007 ,Can you share sample data and sample output.