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

How to only display certain rows

New to Power BI. Let me try to explain my question. I have connected to a LIVE database and want to create a table that only shows rows if a cell that contains some date is more recent than another date in a different cell in the same row. By more recent I mean let's say one cells says 10/01/2021 and another 02/10/2023, then I want this row to be displayed. But if the latter is older than the former then it shouldn't be displayed. Hope it makes sense. Please help! 

1 REPLY 1
lbendlin
Super User
Super User

you cannot add columns to live connection data sources.  But you can convert these to Direct Query with local model. Then you can add your columns and use them as filters.

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.