cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors