..

[v-xuding-msft]

Hi @Anonymous ,

Do you have resolved it? If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

[amitchandak]

@Anonymous , I can see modified on has timestamp.

Whatever date you join with date table should not have a time stamp.

Create a date like this.

Modified Date =[Modified on].Date

Join this date table. You should able to get the correct result.  If there is any other column, check and do same.