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.
本文标签:
版权声明:本文标题:powerbi - How to create 1 slicer to do filtering based on the values of 2 date type columns? (Start and End Date) - Stack Overfl 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1744262416a2597782.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论