Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am struggling with how do I get my data in a Table Visual to show only data that is based on a slicer date. So I put in the date, but I want all data that is before or on that date. That is my start date. Then I have an End Date, but I want that to be before or on that date or null.
Here is how I visualize the query for the data.
[Start Date] <= [Begin Date] and
([End Date] >= [Finish Date] or [End Date] = null)
How do I do that in Power BI Desktop?
I tried to use the date in the Table as a filter and used "is on or before" but I have to enter the date each time I use the report. I was hoping the slicer could give me the date to fill the filter.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |