Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a "requests" dataset which includes both a StartDate and an EndDate column. I need to create a slicer that will filter in any records where either the StartDate or EndDate falls within a date range as defined by the slicer. Is this possible, or will I be required to have individual slicers for StartDate and EndDate?
Here is one way of handling it (pbix file here😞
Date is a standard date table
With this model, you can now apply filters on the Date table and the Sales table will be filtered to rows where either StartDate or EndDate meets the filter criteria.
Also, you could filter on Date Type if you wanted the Date filter to apply to StartDate or EndDate only.
Regards,
Owen
Hi @AaronJarboe,
Does that make sense? If so, kindly mark the answer as solution to close the case.
Regards,
Frank
Hi @AaronJarboe,
I made one sample for your reference.
1. Create the relationship between tables as below.
2. Create the measures.
End = CALCULATE(SUM(Table1[sales]),USERELATIONSHIP('CALENDAR'[Date],Table1[End date]))
St = CALCULATE(SUM(Table1[sales]))
For more details, please check the pbix as attached.
Regards,
Frank
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |