Forum Discussion

hawkwolfe's avatar
hawkwolfe
New Member
4 years ago
Solved

Filter by status change date

I am working with a file containing event data associated with agents, and have recently gotten access to a second table containing agent hierarchy data. With this hierarchy, I will now need to provi...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi， hawkwolfe 

    Try calculated columns:

    date_agent = LOOKUPVALUE('Hierarchy table'[Date],'Hierarchy table'[Name],'call agent date'[agent],'Hierarchy table'[Status],"agent") 
    filter = IF('call agent date'[date]<='call agent date'[date_agent],1,0)

    Then apply the filter to visual filter pane.

    Best Regards,
    Community Support Team _ Eason

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi， hawkwolfe 

Try calculated columns:

date_agent = LOOKUPVALUE('Hierarchy table'[Date],'Hierarchy table'[Name],'call agent date'[agent],'Hierarchy table'[Status],"agent") 
filter = IF('call agent date'[date]<='call agent date'[date_agent],1,0)

Then apply the filter to visual filter pane.

Best Regards,
Community Support Team _ Eason