Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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: 

 

Jack_Reacher_0-1678925452662.png

 

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:

Jack_Reacher_1-1678932190675.png

 

Jack_Reacher_0-1678931675771.png

 

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

Jack_Reacher_2-1678932667100.png

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , 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-trend/ba-p/882970

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.