Forum Discussion

MrMike's avatar
MrMike
Helper II
5 years ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

MrMike's avatar
MrMike
Helper II
5 years ago

I read the article and created custom calendar date table. The results are still wrong. When I select Start Date 2/15/2021 and End Date 3/20/2021 no rows in table show, I expect to see Science and English.

MrMike's avatar
MrMike
Helper II
5 years ago

Also when I select Start Date 2/1/2021 and End Date 3/1/2021 only Science shows. I would expect to see Math, Science and English, because those 3 classes are within the date range 2/1/2021 and 3/1/2021.