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
Divinal_ThiagoP
Regular Visitor

Filtering data from PostgreSQL with no date field in Power BI

Hi everyone,

 

I'm new to Power BI and I'm having some trouble connecting to a PostgreSQL database and importing the data.

 

Background:

  • My company uses a PostgreSQL database.
  • I'm using ODBC to connect to the database.
  • I need to filter the data to only include the last 2 years.
    • Example: If you are in 2024, I need the data from 2023 and 2022. But next year (2025), the data selection should automatically update to only include data from 2023 onwards.
  • Some tables don't have a date field.

My question is: which is the most eficient way to filter this data?

 

Thanks in advance for your help!

 

1 ACCEPTED SOLUTION
Sahir_Maharaj
Super User
Super User

Hello @Divinal_ThiagoP,

 

You could write a query that joins your target table with the date-containing table and filters based on the date:

SELECT t.*, d.date_field
FROM target_table t
JOIN date_table d ON t.date_id = d.id
WHERE d.date_field >= CURRENT_DATE - INTERVAL '2 years'

 

Hope this helps!


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

View solution in original post

1 REPLY 1
Sahir_Maharaj
Super User
Super User

Hello @Divinal_ThiagoP,

 

You could write a query that joins your target table with the date-containing table and filters based on the date:

SELECT t.*, d.date_field
FROM target_table t
JOIN date_table d ON t.date_id = d.id
WHERE d.date_field >= CURRENT_DATE - INTERVAL '2 years'

 

Hope this helps!


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution? (Yes, its FREE!)
➤ Lets connect on LinkedIn: Join my network of 15K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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