I'm fairly new to Power BI and hoping someone can offer some suggestions on the below. I've looked up calendar tables etc but not sure if that will be any benefit. In short, i'm looking to have two slicers with the below table. For example, I want Key's resolved before 19/04/2020 but created before 30/04/2020 however, if not resolved, to include.
With the slicers working, I would be able to get the following:
Any ideas greatly appreciated.
Solved! Go to Solution.
@NiugeS you surely need calendar table one for created before selection and one for resolve after selection, one you have these table and slicers, it is super easy from there.
@parry2k THank you for the feedback. So I need to create two calendar tables? One for created and one for resolved? I've not made a calendar table so will look that up i'm sure there are lots of posts on that here.
@parry2k Thank you. It took me a bit of time to undertand the measure and try and put it into another pbix. Thanks for the help, greatly appreciated.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!