Forum Discussion
Issue with start/end date filtering
- Anonymous1 year ago
Hi, Anonymous
Thanks for Ashish_Mathur and audreygerred reply. Using the same data structure as you, it seems to work fine.You can refer to their suggestions, or refer to the following dax.
Filter = VAR _startDate = MIN('Date Start 2'[DateStart]) VAR _endDate = MAX('Date End 2'[Date End]) VAR _created = SELECTEDVALUE('Distinct'[Created]) VAR _expired = SELECTEDVALUE('Distinct'[Expired]) VAR _result = IF(_created>=_startDate && _expired<=_endDate,1,0) RETURN _resultBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi,
Why create 2 date slicers? Why not a single date slicer with the between functionality.
- Anonymous1 year agoNot applicable
because I have 2 fields, created and expired, can I connect one between slicer to both fields somehow? thanks