Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
STIBBS_807
Resolver I
Resolver I

Get Data Before the Date in a slicer

I am struggling with how do I get my data in a Table Visual to show only data that is based on a slicer date.  So I put in the date, but I want all data that is before or on that date.  That is my start date.  Then I have an End Date, but I want that to be before or on that date or null.

 

Here is how I visualize the query for the data.

 

[Start Date] <= [Begin Date] and

([End Date] >= [Finish Date] or [End Date] = null)

 

How do I do that in Power BI Desktop?

1 REPLY 1
STIBBS_807
Resolver I
Resolver I

 I tried to use the date in the Table as a filter and used "is on or before" but I have to enter the date each time I use the report.  I was hoping the slicer could give me the date to fill the filter.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.