Table showing data from previous or upcoming month when selecting the current month

[Jack_Reacher]

I have a table in Power BI that displays data based on the selected month from the drop-down filter. However, when I select a specific month, the table shows data from the previous or upcoming month as well, in addition to the selected month. This issue is causing a discrepancy in my data analysis.

Picture of the table showing data from the previous or upcoming month: 

I have checked the data source and confirmed that there are no data errors. I have also checked the filters in the table and confirmed that they are set up correctly. I am not sure what else could be causing this issue.

Can anyone help me troubleshoot this issue? Any suggestions or guidance would be greatly appreciated.

Thank you in advance for your help!

I use a merged table of Datemin and Datemax as shown below:

I also use a Power Query Formula to calculate the 'Reception date" Column:
Processing time = [DATE REPONSE]-[DATE RECEPTION]

[amitchandak]

@Jack_Reacher , Ideally you should join truncated response and reception dates to date table a and use date table for analysis. One join will be inactive and you can userelationship to activate that

response dt = datevalue(Table[response date])

Refer to how to deal with two-dates

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

[Jack_Reacher]

I'm pretty much new to Power Bi can you please elaborate more on this ?