Forum Discussion
Anonymous
1 year agoNot applicable
Filter table based on date ranger slicer
I have a transaction table with several date columns and also a date dimension table defined in Power BI. For example, the transaction table contains Order, Customer, Country, OrderStart,OrderEnd,Sh...
- 1 year ago
Hi Anonymous,
Thank you for reaching out to the Microsoft fabric community forum. Thank you bhanu_gautam, for your input on this issue.After thoroughly reviewing the details you provided, I was able to reproduce the scenario, I have used it as sample data on my end and successfully implemented it.
Dax Measure:
IsWithinSelectedRange = VAR SelectedStart = MIN('01. Dim_Date'[Date]) VAR SelectedEnd = MAX('01. Dim_Date'[Date]) RETURN IF ( MIN(Fact_RO_Contract'[OrderStart]) >= SelectedStart && MAX(Fact_RO_Contract'[OrderEnd]) <= SelectedEnd && MIN(Fact_RO_Contract'[DeliveryStart]) >= SelectedStart && MAX(Fact_RO_Contract'[DeliveryEnd]) <= SelectedEnd && MIN(Fact_RO_Contract'[ShipmentStart]) >= SelectedStart && MAX(Fact_RO_Contract'[ShipmentEnd]) <= SelectedEnd, 1, 0 )Output:
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Ashish_Excel
Solution Supplier
1 year agoHi,
Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.