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.

Helper I
Helper I

Filtering Data Based on a Date Table and 2 Date Columns in a Second Table

Hey all,

I have a table with 2 date columns, DateBought and DateSold. Every item in the report will have a date bought value, since all items in the date were bought, but items that have not been sold will have a null DateSold table. I've made a mockup table below.


I want to create a slicer that will allow me to filter to if one of the columns is in the date range.

So, for example, if the date range is 1/10/2022 to 1/14/2022, it should return the columns 1, 3, and 5. From there, I want to count how many were bought in this time range (DateBought is in the range of the slicer) and how many were sold in this time range (DateSold is in the range of the slicer). For the example as before, there was 1 bought (5) and 3 sold (1, 3, and 5) during this time range.


Any advice is greatly appreciated. I can split the data so that its two separate tables with the same columns, just with the values already bought or sold split into separate tables.

Super User
Super User

@jarwest , You need to create a date table and join both dates with that. One join will be active and one will be inactive, you can use userelationship in measure to activate the join


Power BI: HR Analytics - Employees as on Date :

Wouldn't that filter if both dates are in range? I need to filter on if DateBought or DateSold are in this range, but if I understand this correctly it would filter on if DateBought and DateSold are in this range.

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.

Top Solution Authors
Top Kudoed Authors