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.

New Member

Select first row metting condition

Hi, I have a table (PRODUCT) with product data and a creation datetime. I have a second table (PERIOD) with year, sale period, and start / end date of those period.


I try to create a column in PRODUCT containing the row of PERIOD when my creation datetime is between start date and end date. Right now, I have this formula ("period" is a step before where I ref the second table):

Table.AddColumn(#"Step before", "PERIOD", each Table.SelectRows(period, (v_period) => ([DATETIMECREATION] >= v_period[STARTDATE] and [DATETIMECREATION] <= v_period[ENDDATE])))


I have the good result, but since I have ~400 row in PERIOD and maybe 4 000 000 rows in product, is there a better way ? I've try a conditional join but without sucess. And Table.First don't take condition. I use SelectRows but only get one result each time.

Super User
Super User

Flip the loops around (each and (v_period).  Also try it with the tables flipped around. Then try it with Table.AddKey for your join condition columns.


If you can, provide meaningful sample data.   That  will allow us to suggest the most performant approach.

Helpful resources

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.