Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
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.
Key | Created | Resolved |
1 | 15/03/2020 | 18/04/2020 |
2 | 18/03/2020 | |
3 | 25/03/2020 | 20/04/2020 |
4 | 28/03/2020 | 25/04/2020 |
5 | 31/03/2020 | 30/04/2020 |
With the slicers working, I would be able to get the following:
2 | 18/03/2020 | |
3 | 25/03/2020 | 20/04/2020 |
4 | 28/03/2020 | 25/04/2020 |
Any ideas greatly appreciated.
Thank you
@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.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
I've created the two calendar tables however i'm still having a bit of difficulty. If I set the resolved slicer for 19/04/2020, the row with the blank date is removed. I have attached an example PBIX file in case i'm doing something wrong Date Pbix Example
Thank you
@NiugeS see attached.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |