admin管理员组

文章数量:1410737

I'm new to Power BI and would really appreciate any input on this.

By taking the table below as an example.

;px=-1

I'm looking to create a slicer and let's call it "Project Year" and it should return all the related projects (e.g. by selecting 2022 in the slicer, we should get project A and B because project B started in 2021 and ended in 2024, hence 2022 and 2023 (the years in between) are considered as its project years too).

Would like to highlight that there are projects with only start date or end date being entered, and also projects without any date being entered yet. Projects with both blank start and end date need to be presented when there's no values selected on the slicer and by selecting 2022 in the slicer, would also like to include those with only start date/end date being entered as 2022

Can refer to more examples below.

;px=-1

Thank you.

本文标签: