Forum Discussion
Solved
Rows between two dates
In Power BI desktop, how to show rows that are between a start date and end date? Also which visualation to use? Is slicer the best option? For example, my data is like this: Start Date End ...
Hi MrMike ,
Here are the steps you can follow：
1. Create measure.
Flag1 = var _selectedperiod= SELECTCOLUMNS(ALLSELECTED('date'),"Date", [Date]) return IF(MAX('Table'[Start Date]) in _selectedperiod||MAX('Table'[End Date]) in _selectedperiod|| (MAX('Table'[Start Date])<=MIN('date'[Date])&&MAX('Table'[End Date])>=MAX('date'[Date])) ,1,0)2. Result
You can downloaded PBIX file from here.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I created a new test example power bi report file for this issue. How do I attach a .pbix file to this post?